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
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