How to write this SQL?

shuyuan641

There is a data sheet

A1 A2 mem
1001 11 Good
1001 211 Good 1
1002 SS bad
1002 DD bad
..

I want to display the first record with the same content in the A1 field
A1 A2 mem
1001 11 Good
1002 SS bad

小老鹰

select A1, first (A2), first (mem)
from table name
group by A1

cairui1

It is best to add an auto-increment field and then write the SQL statement.

ilgold

select A1, first (A2), first (mem)
from table name
group by A1



－Agree with this

jieerjerry

SELECT tt.A1, first(tt.A2) AS A2, first(tt.mem) AS mem
FROM tt
GROUP BY tt.A1
This is more accurate, using the same name field and solving the problem of circular reference parameters.