再次求教在有重复名称记录中找最小编码的SQL

显示全部楼层 · 2005-8-4 19:18:00

BM
MC

001
t1
001
t1
002
t2
003
t2

003
t3
004
t3
SELECT DISTINCT [bm],[mc] FROM [table] WHERE [bm] IN (SELECT MIN([bm]) FROM [table] GROUP BY [mc])
得出的结果为:

001
t1

002
t2

003
t2

003
t3
但我需要的结果为:

001
t1

002
t2

003
t3
如何解决,望赐教.

千问 · 2005-8-4 19:18:00

把SELECT DISTINCT [bm],[mc] FROM [table] WHERE [bm] IN (SELECT MIN([bm]) FROM [table] GROUP BY [mc])做成view，然后对view进行查询就可以了阿

千问 · 2005-8-4 19:18:00

谢谢