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

Stryg for at vise menuen

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


              
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
Vi beklager, at noget gik galt. Hvad skete der?

Spørg AI

expand
ChatGPT

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

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


              
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
Switch to desktopSkift til skrivebord for at øve i den virkelige verdenFortsæt der, hvor du er, med en af nedenstående muligheder
Vi beklager, at noget gik galt. Hvad skete der?
some-alt