Loading

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

Abhilash J A

10y847SQL

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhilash J A10y ago
Solved:

http://stackoverflow.com/questions/18031421/the-order-by-clause-is-invalid-in-views-inline-functions-derived-tables-subqu
Ranjit Powar10y ago
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