SELECT statement with a maximum of rows, or the first or the last.

[YipYeppp]

Hi !!

Sure it is a really easy question.. but i've been searching a lot to find nothing.
I want to know how to make a SELECT statement and specify the maximum number of rows i want to have in the result. Also need to know how to specify that i want only the first or the last one of the table..
Thanks a looooooot !!

 

[carp]

This is one of those questions whose answer will depend on the RDBMS you are using.
If you are using Oracle, you would use
WHERE rownum <= 100
to get the first 100 rows.

 

[YipYeppp]

Hey.. thanks a lot !!

YipYeppppppppp is a happy girl now!!