hi pals,

Here is my question:
I have to get the top 2 people for each year who have achieved the
target.
Eg:
Year Name Target
1995 ABC 200
1995 XYZ 100
1996 XYZ 200
1996 PQR 100

Table Design

Table 1:
Id Name
1 ABC
2 XYZ
3 PQR

Table 2:
Tid id Year Target
1 1 1995 200
2 2 1995 100
3 3 1995 50
4 2 1996 200
5 1 1996 50
6 3 1996 100

Regards,
Praveen K R

______________________________________________________________________

Oracle LazyDBA home page