Select each record from the table without repeating one record

Question

How to select each record without repeating the same record?

Example:

ID            item
------       -------
ABC          item 1
XXX          item 2
AXA          item 3
ABC          item 4
XXX          item 5

From the table above, I just want to select each entry, such as ABC, XXX and AXA, without repeating it. How to do it in MS SQL 2005?

+5

Genjo Mar 6 '13 at 4:38

7 answers

Use the keyword distinct:

Select distinct id from TABLE;

+2

Marc Mar 6 '13 at 4:40

SELECT DISTINCT ID from YourTable

+2

TechDo 06 . '13 4:40

Select Distinct ID from tablename

+2

Tassadaque 06 . '13 4:40

DISTINCT () .

SELECT DISTINCT you_column_name FROM your_table_name

+2

DISTINCT () .

, :

SELECT DISTINCT ID FROM Table_name

+2

Futuregeek Mar 6 '13 at 4:55

select a separate identifier from tablename

+1

Dhanya raj Mar 6 '13 at 5:01

Sumit mudkondwar · Accepted Answer · 2013-03-06T04:45:51+0000

You must use the keyword "DISTINCT" to retrieve individual records, you can use the following query,

"SELECT DISTINCT ID FROM"