想要SQL Query的帮助 [英] Want help for SQL Query

问题描述

嗨..



我有桌上人（身份证，姓名，金额）。我想从表中选择具有不同名称及其ID和金额的记录。



赞

Id名称金额

1 ABC 2000

2 XYZ 6000

3 ABC 3000

4 PQR 4000



然后结果



Id名称金额

1 ABC 2000

2 XYZ 6000
4 PQR 4000



提前谢谢.. :)

Hi..

I have table person(Id,Name,Amount). I want to select records from table with distinct name with their id and Amount.

Like
Id Name Amount
1 ABC 2000
2 XYZ 6000
3 ABC 3000
4 PQR 4000

then result

Id Name Amount
1 ABC 2000
2 XYZ 6000
4 PQR 4000

Thanks in advance.. :)

推荐答案

试试

Try

SELECT P.Id, P.Name, P.Amount FROM person P
INNER JOIN 
(
   SELECT Min(Id) AS Id, Name FROM person
   GROUP BY Name
) T ON P.Id = T.Id

这篇关于想要SQL Query的帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！