Hello to all,
I have table like "User". Below is the structure and data of it.
Code Name EFFECTIVE_DATE (dd/mm/yyyy)
=====================
s1 Tom 1/5/2005
s2 Alexa 1/6/2005
s2 Alexa 15/6/2005
I want query that produces the following output
Code Name EFFECTIVE_DATE (dd/mm/yyyy)
=====================
s1 Tom 1/5/2005
s2 Alexa 15/6/2005
Can anyone tell me how to select unique records from a table? Please help me.
Thank you.
Bookmarks