Dear Friend
Can any one please tell me how can i remove the duplicates data and i want only 1 unique records
i have the table having these structure
Create table xyz(srno numeric,sname varchar(12),age numeric)
srno sname age
1 manish 26
1 manish 26
1 manish 26
2 Rohan 27
2 Rohan 27
3 Riyaz 28
3 Riyaz 28
3 Riyaz 28
4 shabbir 29
4 shabbir 29
4 shabbir 29
4 shabbir 29