Select each record from table without repeating same record

Question

How do I 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 record such as ABC, XXX and AXA without repeating it. How do I do so in MS SQL 2005?

Answer 1

You have to use "DISTINCT" Keyword for getting distinct records you can use the following query,

"SELECT DISTINCT ID FROM "

Answer 2

Use the distinct key word:

Select distinct id from TABLE;