I'm looking for a little SQL help please

[Punt]

Hi,

I'm not much of a SQLer so looking for a little help.

Say I have the following table in SQL...

I'm trying to build a sql string that returns the first instance of each [Username] based on the lowest [Index].

The resulting table would be...

Many thanks

 

[Punt]

Afraid not...

Error...

"Column 'String' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."

 

[Punt]

That returns everything.

 

[Punt]

Can't use MIN(String) as I can't (don't want to) test against the value of a string.

Another way would be

SELECT * FROM Table A
WHERE A.index=(SELECT MIN(A1.index) FROM Table A1 WHERE A.Username=A1.Username))

This seems to do the trick

Cheers everyone for their help.