Skip to Content
0
Former Member
Dec 11, 2006 at 05:50 AM

select query

31 Views

hi,

My requirement is to select records from a table based on a field (say abc )which has the max value.i.e. if field abc has value 2 & corresponding to this no. of records is 3 & the other value of abc is 4 which has the no. of records corresponding to it as 5 then i have to select first record with field abc = 4 & if two values of abc have equal no. of records then select whichever comes first.

pls guide me for the same.

Helpful answers will be rewarded.

Regards,

Sipra