Challenge Order By
Remember how to order the records by multiple columns. Let's say, you want to order all records by singer's name first and then by song's title:
9
1
2
SELECT * FROM songs
ORDER BY singer, title
12SELECT * FROM songs ORDER BY singer, title
Tarea
Swipe to start coding
Select records with AC/DC songs, and order it by title
from A to Z, and then by album
from Z to A.
Solución
9
1
2
3
select * from songs
where singer = 'AC/DC'
order by title, album desc
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 3. Capítulo 6
9
1
No query executed yet... |
Pregunte a AI
Pregunte lo que quiera o pruebe una de las preguntas sugeridas para comenzar nuestra charla