Answers for "select order by"

select sql order

SELECT naslov, stranice AS broj
FROM knjige
ORDER BY broj DESC

sql order by

Used to sort the result data in ascending (default) or descending order
through the use of ASC or DESC keywords.
Example: Returns countries in alphabetical order.
SELECT * FROM countries
ORDER BY name;