computer science Karteikarten am SQL flash cards, erstellt von Janine Love am 09/03/2019.
|
Erstellt von Janine Love
vor etwa 7 Jahre
|
|
Schließen
|
|
Erstellt von Janine Love
vor etwa 7 Jahre
|
|
UPDATE (definition)
UPDATE the first customer (CustomerID = 1) with a new contact person and a new city.
IF() (definition)
Given a table salary, such as the one below, that has m=male and f=female values. Swap all f and m values (i.e., change all f values to m and vice versa) with a single update statement and no intermediate temp table.
output movies with an odd numbered ID and a description that is not 'boring'. Order the result by rating.
GROUP BY
HAVING clause
List the number of customers in each country, ordered by the country with the most customers first.
LEFT (outer) JOIN
