Last 20 records

[new2ora]

Hi,

My table has the production data from 3 months. I want to see only the last 20 shifts. The table can include any number of months so the shift count is not the same.

So far i am able to sort the shifts decending, I just want to pick the top 20.

Suggestion?

Thanks

 

[PHV]

Have a look at the TOP predicate:
SELECT TOP 20 ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886