Hello, I need to grad the first

[wuwang]

Hello,

I need to grad the first 50 records from a table
base on primary key.
Is there any function in SQL or SQL*Plus doing this?

Thanks you for your help.

Jimmy

 

[carp]

SELECT *
FROM (SELECT * FROM my_table ORDER BY your_primary_key_column ASC)
WHERE rownum < 51;