select * from Cay_ChaoRenPhotoList where phl_id in (
select max(phl_Id) as phl_id from Cay_ChaoRenPhotoList
where Phl_RenQiNum
in
(select max(Phl_RenQiNum) as Phl_RenQiNum
from Cay_ChaoRenPhotoList group by Use_ID,Phl_CrlID having Phl_CrlID=1 ) group by use_ID
)
select phl_id,use_id from Cay_ChaoRenPhotoList
where Phl_RenQiNum
in
(select max(Phl_RenQiNum) as Phl_RenQiNum
from Cay_ChaoRenPhotoList group by Use_ID,Phl_CrlID having Phl_CrlID=1 )
一段sql语句,备忘!
最新推荐文章于 2023-05-04 18:43:52 发布