Re: SQL question (retriveing n number of rows)
I do not know what is the criteria for the set , but for example fist 50
rows with smallest rowids:
select * from tab1 a
where 50 > (select count(*) from tab1 b
where a.rowid < b.rowid)
For sufficient large tables it's gonna take a while :-)
Boris Niyazov
Programmer/DBA
IT Department , Columbia Law School
>How do I retrieve a set number of rows in a SQL select.
>
>If my select is something like:
>select * from tab1 where x = y.>
>how do I retrieve only the first 50 rows.>
>
>-Toby Denbow
>tdenbow@mathworks.com