hiiiiiiii,I have 3 columns no keys on that table
a,b and c
a contains 20rows but it has same values i mean dublicate data.
b also have 20 records with dublicate dat.
My question is shall i use distinct on "a" i mean (it will display five exact rows without dublication) but mean while i need to dislay all 20 records from "b".
i hope any one can help me