SELECT DISTINCT

[gustaf111]

SELECT DISTINCT (Name), Computer, FROM table1;

Hello, I have a table that contains two colums, Name and Computer. I would like to list the name only ones and display the corresponding value to the Name.

Example

Name Computer
=====
Andy Data1
Andy Data2
Nick Data1
Nick Data2
Marget Data1


I would like to have the result:
Andy Data1
Nick Data1
Marget Data1

How do I do that ? Please Help!!

 

[r937]

SELECT name
     , MIN(Computer)
  FROM daTable
GROUP
    BY name

i should note in passing that DISTINCT is ~not~ a function, so please don't go putting parentheses around the first column that comes after the DISTINCT keyword

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[gustaf111]

Thanks!!