求问一个SQL语句问题。各路大神帮帮忙。。。

[x582053774]

IDa 都不一样，IDb是另一张表的外键，我想取IDb一样的情况下，IDa最小的数据。

结果如下图

求SQL语句。。。完全没思路。。。各路大神素来~~

[「已注销」]

自己顶个！！！！

[發糞塗牆]

SELECT  *
FROM    tb a
WHERE   EXISTS ( SELECT 1
                 FROM   ( SELECT    comunidb ,
                                    MAX(columnida) columnida
                          FROM      tb
                          GROUP BY  comunidb
                        ) b
                 WHERE  a.columnida = b.columnida
                        AND a.comunidb = b.comunidb )

[MrYangkang]

这样行吗 select a,b,c,d,min(status),min(ida),min(idb) from table1 group by a,b,c,d

[guguda2008]

SELECT *
FROM (
SELECT *
,ROW_NUMBER() OVER (PARTITION BY IDB ORDER BY IDA) AS NUM
FROM TB
) T WHERE NUM=1

[「已注销」]

引用 2 楼 DBA_Huangzj 的回复:

SELECT  *
FROM    tb a
WHERE   EXISTS ( SELECT 1
                 FROM   ( SELECT    comunidb ,
                                    MAX(columnida) columnida
                          FROM      tb
                          GROUP BY  comunidb
                        ) b
                 WHERE  a.columnida = b.columnida
                        AND a.comunidb = b.comunidb )

谢谢大家，已解决!!!此方法可行。。

[dengixnyu]

select * from (
select min(ColumnIda) over (PARTITION BY ColumnIdb) as newid1,* from table1
)a where a.newid1 = a.ColumnIda order by ColumnIda