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 )
这样行吗 select a,b,c,d,min(status),min(ida),min(idb) from table1 group by a,b,c,d
SELECT * FROM ( SELECT * ,ROW_NUMBER() OVER (PARTITION BY IDB ORDER BY IDA) AS NUM FROM TB ) T WHERE NUM=1
select * from ( select min(ColumnIda) over (PARTITION BY ColumnIdb) as newid1,* from table1 )a where a.newid1 = a.ColumnIda order by ColumnIda
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 )
select a,b,c,d,min(status),min(ida),min(idb) from table1
group by a,b,c,d
FROM (
SELECT *
,ROW_NUMBER() OVER (PARTITION BY IDB ORDER BY IDA) AS NUM
FROM TB
) T WHERE NUM=1
select * from (
select min(ColumnIda) over (PARTITION BY ColumnIdb) as newid1,* from table1
)a where a.newid1 = a.ColumnIda order by ColumnIda