Hi All,
Greetings .....
I am wondering if you can answer me this question ...
suppose ... a table contains rows and and many rows are duplicate ..
I want to store only the UNIQUE rows in the table ...
I dont want to use any temp. table , cursor etccc for that activity ...
Can you please help me ....
Thanks in Advance :)
I have table <contact>
I wand to higllight the duplicate student .I am considering two parameter Name and Birthdate to identify such records even though the probablity of two different student having same name and same DOB is very less.Margin for bad result is relatively low for me.
fisrtname middlename lastName birthdate
------------------------------------------------
peter jones clooney 29/06/2008
peter jones clooney 29/06/2008
both are actually same student but different from database point of view.