I have a table like this:
| songtitle | songlength |
|------------|-------------|
| 1 | 3:42 |
| 2 | 1:32 |
| 3 | 2:44 |
| 4 | 5:00 |
| 5 | 1:19 |
| 6 | 2:54 |
And I want to get the 3 shortest songs (sorted shortest to longest).
I figure I will need something like LIMIT but I'm not positive. Thanks
Sort the data and limit the number of rows you want to retreive:
select *
from your_table
order by songlength
limit 3;
If you'd like to get the 3 longest songs, simply order the data in descending order:
select *
from your_table
order by songlength desc
limit 3;
Addressing Dwza's comment, quoting from MySQL Reference Manual:
Columns selected for output can be referred to in
ORDER BYandGROUP BYclauses using column names, column aliases, or column positions. [...] To sort in reverse order, add theDESC(descending) keyword to the name of the column in theORDER BYclause that you are sorting by. The default is ascending order; this can be specified explicitly using theASCkeyword.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments