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