hi all,
Iam new to Oracle and am looking for the equivalent of Limit in oracle.
Just as in MySQL, i use limit for retrieving first 5 rows or whatever how can i do the same in oracle?
I have tried using rownum but its giving me differnet results which i feel i s incorrect.
like in my query,
select name,cname,age,title,count(*) as cnt from test where rownum < 5 group by name,cname,age,title order by cnt ;
This produces vague results,
Iamnot getting the first 5 rows as i wanted
instead it is checking fo rthe count value to be < 5 and displays records whichevr has count < 5
How am i supposed to get just the first 5 rows,or 10 rows in oracle?
like in MSSQL atleast we have 'top n'
What is it in oracle?
kindly let me know soon
Regards
Roopa
