Databaser och Python Flashcards

1
Q

SQL Query syntax

A
SELECT [* | DISTINCT] column1 [,column2]
      FROM table1 [,table2]
         [WHERE "conditions"]
             [GROUP BY "column-list"]
                   [HAVING "conditions"]
                        [ORDER BY "column-list" [ASC | DESC] ] ;
How well did you know this?
1
Not at all
2
3
4
5
Perfectly