Select unique records from a table

[Conraad]

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.

[Praetor]

Hey you have to write following Sql query to get unique record from the table. It is very simple to use. In the following code DISTINCT clause is used to get unique record from the specifying table. In the following code I use FROM clause to get data from the table name "user".

SELECT DISTINCT Name FROM user

[Katty]

If you want to copy distinct records from one table to another then you have to use following code. In the following code I have use DISTINCT clause to remove duplicate record from the table and gives you single unique record. Just try to understand it.

 INSERT INTO tables1 VALUES (SELECT DISTINCT x,y,z.. FROM user)

[kelfro]

Hey why don't you remove duplicate record from your table. I have written following SQL for you. Just try to understand it. I have written one of the example of it. In the following code I have use GROUP BY clause.

 
SELECT * FROM emps as
WHERE rowids = (SELECT maxs(rowids) FROM emps
WHERE empnos = as.empnos
GROUP BY empnos
HAVING count(*) >1)

[Zecho]

As per my information you have to use GROUP BY clause to get rid out of this problem. I have given one example of GROUP BY clause. Just try to understand each steps.

select ids, term from project_term WHERE pids='$_SESSION[project_ids]' GROUP BY terms

This GROUP BY clause is used to group all the terms which are same.

[absolute55]

In a table, some of the columns may contain duplicate values. This is not a problem, however, sometimes you will want to list only the different (distinct) values in a table.

The DISTINCT keyword can be used to return only distinct (different) values.
SQL SELECT DISTINCT Syntax
SELECT DISTINCT column_name(s)
FROM table_name