Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

last 20 records for each group

Status
Not open for further replies.

ianoctdec

Programmer
Feb 6, 2003
190
CA
Hi,

I am building a Crystal report (CR10) and I need a query that will return the last 20 wo's for each part.
I have a table like this (each part can have many wo's):

Part wo
1 1
1 2
1 3
2 5
2 7
2 8
3 9

I have Oracle 8i, but don't have analytical functions.
Can this be achieved with plain Oracle SQL?

Thank you,
Dana


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top