Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Lære Challenge Order By | Filtering Statements
SQL Tutorial for Beginners

bookChallenge 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:


              
12

            
SELECT * FROM songs
ORDER BY singer, title
copy
Opgave

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øsning

Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 3. Kapitel 6
single

single

Spørg AI

expand

Spørg AI

ChatGPT

Spørg om hvad som helst eller prøv et af de foreslåede spørgsmål for at starte vores chat

Suggested prompts:

Opsummér dette kapitel

Explain code

Explain why doesn't solve task

close

Awesome!

Completion rate improved to 4.17

bookChallenge Order By

Stryg for at vise menuen

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:


              
12

            
SELECT * FROM songs
ORDER BY singer, title
copy
Opgave

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øsning

Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Var alt klart?

Hvordan kan vi forbedre det?

Tak for dine kommentarer!

Sektion 3. Kapitel 6
single

single

some-alt