In Oracle, is it possible to get only first 250 records? I think, in Sql server you can write select statement to access first 250 records. <BR>Any Suggestions.
I tried something like rownum < 251 and that works, but want to do it in different way like <BR>select top 250 from anc
Wow, look what the first result from Google.com was!<BR><BR>http://gethelp.devx.com/techtips/oracle_pro/10min/10min1200/10min1200.asp<BR><BR>("oracle top records")
forgot to mention one thing. the reason why I am not using rownum is because we are trying to get first 250 best matching records(like you do in google.com to get best matching records). We are using intermedia search criteria to find thse records.