[Twinki]

I just want to select 300 records from a table, how do I do that in SQL ?
is there a special option I can set? please help

[r123456]

Hi,

To select the first 300 rows from a table use

Select *
from table
where rownum < 301

However if your DB does not use support rownum, then add
GROUP BY list
HAVING COUNT(*) = x
where list = select list

or If you want to select all x rows past a rownum (ie, select the next 200 rows after row 300) then this will work, again replace rownum if DB doesn't support it. In addition you can replace the select..minus in the from clause with a view, if this will be done frequently.

select list
from
(select *
from table
minus
select *
from table
where rownum < 301)
group by list
having count(*) = x

[Twinki]

Thanks heaps!

Originally posted by r123456
Hi,

To select the first 300 rows from a table use

Select *
from table
where rownum < 301

However if your DB does not use support rownum, then add
GROUP BY list
HAVING COUNT(*) = x
where list = select list

or If you want to select all x rows past a rownum (ie, select the next 200 rows after row 300) then this will work, again replace rownum if DB doesn't support it. In addition you can replace the select..minus in the from clause with a view, if this will be done frequently.

select list
from
(select *
from table
minus
select *
from table
where rownum < 301)
group by list
having count(*) = x

[r123456]

correction,

rownum = x works fine.