Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Oppiskele SQL Order By | Filtering Statements
SQL Tutorial for Beginners
course content

Kurssisisältö

SQL Tutorial for Beginners

SQL Tutorial for Beginners

1. Database & Introduction to Syntax
Meet the SQLSelect the Songs!SQL Select ColumnSQL DistinctSQL WhereChallenge WhereSQL And, Or, Not
2. SQL Aggregate Functions
SQL Min and MaxChallenge Min and MaxSQL Count, Sum, AvgChallenge Count
3. Filtering Statements
SQL NullSQL LikeChallenge LikeSQL BetweenSQL Order ByChallenge Order BySQL Group ByChallenge Group BySQL Top and LimitSQL AliasesSQL HavingChallenge HavingSQL Comments

book
SQL Order By

To sort your result records, use ORDER BY construction. There is a syntax of query:


              
12345

            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...
copy

ORDER BY is at the end of the query, and sorts by one or multiple columns in their order. For example, if there is a construction ORDER BY singer, title, the result will be sorted by singer's name, but for multiple songs of the same singer, records will be sorted by title.

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              
123

            
SELECT id, title, year
FROM songs
ORDER BY year DESC
copy

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tehtävä

Swipe to start coding

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 3. Luku 5
toggle bottom row

book
SQL Order By

To sort your result records, use ORDER BY construction. There is a syntax of query:


              
12345

            
-- do not run this query
SELECT col1, col2, ...
FROM table
WHERE condition
ORDER BY some_col1, some_col2, ...
copy

ORDER BY is at the end of the query, and sorts by one or multiple columns in their order. For example, if there is a construction ORDER BY singer, title, the result will be sorted by singer's name, but for multiple songs of the same singer, records will be sorted by title.

By default, sorting is in ascending order, but you can define it. Use ASC and DESC keywords after each column name:


              
123

            
SELECT id, title, year
FROM songs
ORDER BY year DESC
copy

ASC or DESC statement relates to the column name before it. It means, that in ORDER BY title ASC, price DESC first sorts by title in ascending order, and then by price in descending order.

Tehtävä

Swipe to start coding

Create a rating of songs from the most to the least expensive. Display title, singer, and price of these songs.

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 3. Luku 5
Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Pahoittelemme, että jotain meni pieleen. Mitä tapahtui?
some-alt