Hi ,
I would like to show top n records date wise .
Could u please help me ??
Like table woul;d have following entries
Location TS Date Size
UK /BIC/TS1 01.07.2005 10
NW /BIC/TS1 01.07.2005 110
UK /BIC/TS2 02.07.2005 20
NW /BIC/TS2 02.07.2005 20
NW /BIC/TS1 02.07.2005 200
UK /BIC/TS3 03.07.2005 20
NW /BIC/TS3 03.07.2005 30
NW /BIC/TS2 03.07.2005 12
INDIA /BIC/TS3 03.07.2005 130
and Top 2 Records for size by date
Location TS Date Size
NW /BIC/TS1 1072005 110
UK /BIC/TS1 1072005 10
NW /BIC/TS1 2072005 200
NW /BIC/TS2 2072005 20
INDIA /BIC/TS3 3072005 130
NW /BIC/TS3 3072005 30
Every 1 would get point .
Thaks