computer science Fichas sobre SQL flash cards, creado por Janine Love el 09/03/2019.
|
Creado por Janine Love
hace alrededor de 7 años
|
|
Cerrar
|
|
Creado por Janine Love
hace alrededor de 7 años
|
|
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
