DISTICT from two columns

[andnos]

I have this SQL statement:

SELECT DISTINCT co_name, id  FROM user

id is a unique number
co_name has many values that are the same, I am looking for something that will select the first DISTINCT co_name and the id associated with it.

The above SQL doesn't do this, because I think it selects the unique id and the co_name.

 

[r937]

the first DISTINCT co_name? you mean. the lowest value in the table?

could you perhaps show what you mean by way of several example rows?

r937.com | rudy.ca

 

[andnos]

I have:

co_name, id
BigCompany, 1
BigCompany, 2
SmallzCo, 3,
SmallzCo, 4


So, I want to be able to only show BigCompany,1 and SmallzCo,3 from the above data. Meaning, a unique company and the ID associated with it.

 

[r937]

we're getting warm

a unique company and perhaps the lowest id?

select co_name
     , min(id) as lowest_id
  from user
group
    by co_name

r937.com | rudy.ca

 

[andnos]

R937, this works great, thanks.

 

[andnos]

any books you'd recommend on learning MYSQL

 

[r937]

i recommend starting with online tutorials, and then practicing

r937.com | rudy.ca