maheswari19
28 Nov 2007, 10: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
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