Interesting info about "select with order by"

[Syed Zackriya Hussainy]

hi alls,
This site has helped me in many ways, so thought of sharing something which is really important for ppl using JDBC.
problem:
if u use the order by clause with select query, your ResultSet will only be able to fetch first few records.
eg: select user_name from emp order by sno
If you execute the above query i am sure u will be perplexed to see its not working.
solution:
use the query like this.
select * from (select user_name from emp order by sno)
then it will work
hope its useful to all, any further queries plzz feel free to ask

[Bosun Bello]

Really? I have never had any problems with the select statement using order by. This may have to do with your DB and/or DB driver.

[Blake Minghelli]

I've never had any problems either. You might want to run your original query in your sql editor and see how it compares to your ResultSet. I think something else is going on