Podatkovne baze 1

« nazaj

Podatkovne baze 1 - vaje 19.10.2020


Uvod v SQL

SELECT stolpec, st1*st2+st3 AS ime_stolpca
FROM tabela
WHERE (stolpec = vrednost AND stolpec LIKE '_=%') -- npr. 'a=nekaj'
   OR (1+1 = 2 AND st2 = st3)
  AND stolpec IN (
    SELECT ... -- en stolpec
  )
ORDER BY stolpec [ASC | DESC], st2 ...