How to limit rows returned from query?

I need to be able to limit the number of rows returned from my SQL statement any suggestion? Thanks.

WHERE ROWNUM < x

However, there are some considerations here. Search this forum for ROWNUM to find some good threads on the subject.

- Chris

thx chris