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
Joined: Nov 06, 2000
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.
Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Joined: Sep 13, 2002
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
Blake Minghelli<br />SCWCD<br /> <br />"I'd put a quote here but I'm a non-conformist"