22,210
社区成员
发帖
与我相关
我的任务
分享
--1.
select id,字段1,字段2,min(字段3) as 字段3 from tb group by id,字段1,字段2
--2
select * from tb t where 字段3=(select min(字段3) from tb where 字段1=t.字段1 and 字段2=t.字段2)
SELECT id,[字段1],[字段2],MIN(字段3)
FROM
table
GROUP BY id,[字段1],[字段2]
select id , 字段1 , 字段2 , min(字段3) 字段3 from tb group by id , 字段1 , 字段2
select t.* from tb t
where 字段3 =
(select top 1 字段3 from tb where id = t.id and 字段1 = t.字段1 and 字段2 = t.字段2)
order by a.name
SELECT A.* FROM TABLENAME A WHERE NOT EXISTS(SELECT 1 FROM TABLENAME B WHERE
A.ID=B.ID AND A.[字段1]=b.[字段1] and a.[字段2]=b.[字段2] and a.[字段3]>b.[字段3])
select id,字段1,字段2,min(字段3) as 字段3
from tb
group by id,字段1,字段2
SELECT * FROM TB T
WHERE 字段3 =(SELECT MIN(字段3) FROM TB WHERE ID=T.ID AND 字段1=T.字段1)