GROUP BY + SQL Server

[furious5]

Having a bit of a mental block.

If I have a table like this:

code colour
1234 red
1235 red
1236 white
1237 blue
1238 blue

How could return only the first occurence of the colour, along with the code?

I obviously can't to a group by because I have distinct codes.

Thanks in advance

[swampBoogie]

There is no concept of first in a RDBMS. There is no certainty that the order in which you insert records is the same in which the records are retrieved.

You can get the code with highest or lowest value within a group, e.g.

select colour, min(code) from t group by colour

If that is not sufficient you need to explain more.

[longneck]

select color
     , min(code) as code
from theTable
group
    by color

[longneck]

jinx!

[afrika]

select top 1 * from Your_table_name order by username desc

or if you know the code name

select * from users where code = 1234

[furious5]

Thats great, thanks guys!