How to use MAXRECS in query

[Mbroad]

Hi--I am running the following "every nth record" selection query, but would like to also add a MAXRECS ability to this query. how and where do I do this?

select A.*
into SOS_KEYNUMBER2
from SOS_SECOND_RUN A
inner join SOS_TEMP B on A.SID = B.SID
where B.seq % 5 = 0

Thanks--Mark

Government Coder Mark

 

[gmmastros]

The TOP predicate may be what you are looking for.

Ex.

Select top 10 * from table

This will only return 10 records.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom