Skip to Content
0
Former Member
Aug 04, 2005 at 11:57 AM

Top n record of vallue size by date

16 Views

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