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
Aufgabe
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.
Lösung
9
1
2
3
select * from songs
where singer = 'AC/DC'
order by title, album desc
War alles klar?
Danke für Ihr Feedback!
Abschnitt 3. Kapitel 6
9
1
No query executed yet... |
Fragen Sie AI
Fragen Sie alles oder probieren Sie eine der vorgeschlagenen Fragen, um unser Gespräch zu beginnen