How to do first order by then sort using sql query?

Question

This is my query:= select * from (select Questions from Tble_Questions ORDER BY Questions)A WHERE A.Questions between 1 and 10

Error: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

Mani Kandan · Answer

Solved: http://stackoverflow.com/questions/18031421/the-order-by-clause-is-invalid-in-views-inline-functions-derived-tables-subqu

Ranjit Powar · Answer

If you are trying to get questions from 1 to 10 in sorted manner then there is no need of subquery. You can try like this select Questions from Tble_Questions WHERE Questions between 1 and 10 Order by Questions