UC知道sQL语句group by 的问题
来源：百度知道 编辑：UC知道 时间：2024/06/05 04:01:29
表VIEW2
字段名id,ContractCode,name,room,TotalArea,StartDate,EndDate
我现在的SQL语句是:
select name,count(name) as ct from VIEW2 group by name
能在页面的表单中显示:name和每个name重复的次数
我现在还想在表单中显示每个重复name中的(id)最大的的记录中的room和EndDate.应该怎么写???谢谢了!!!!
字段名id,ContractCode,name,room,TotalArea,StartDate,EndDate
我现在的SQL语句是:
select name,count(name) as ct from VIEW2 group by name
能在页面的表单中显示:name和每个name重复的次数
我现在还想在表单中显示每个重复name中的(id)最大的的记录中的room和EndDate.应该怎么写???谢谢了!!!!
select name,count(name) as ct
from VIEW2
group by name
UNION SELECT room,EndDate
from VIEW2
WHERE id IN(SELECT MAX(id) from VIEW2
GROUP BY name)
差不多就这样，我没有环境，你自己再调试调试吧。
select max(id) id,room,EndDate from where name in (select name,count(name) as ct from VIEW2 group by name) group by room,EndDate