PDA

View Full Version : unsorted distinct display



maheswari19
28 Nov 2007, 11:56 PM
Dear Friends

i have a requirement to eliminate the duplicate values from a list...say
i have the following list

CCC
CCC
DDD
DDD
BBB
BBB
AAA
AAA

and i want to display that in the following order

CCC
DDD
BBB
AAA

but if we use distinct or group by, it will sort and display as

AAA
BBB
CCC
DDD

i dont want to display the sorted distinct item....but only the distinct item...

please anybody there help me out with the clear solution.

Thanks in Advance

Mahe