想取图示中序号为5的唯一的那行数据,sql及图示如下,请问该如何修改
图示:
sql:
SELECT distinct [seimei]
,[seqno]
,[gwh]
,max([kssj])as kssj
FROM aa
where seimei = 'MCY-MHP0805HT8-CF'
and seqno = '291A0277'
group by [seimei] ,[seqno],[gwh]
想取图示中序号为5的唯一的那行数据,sql及图示如下,请问该如何修改
图示:
SELECT distinct [seimei]
,[seqno]
,[gwh]
,max([kssj])as kssj
FROM aa
where seimei = 'MCY-MHP0805HT8-CF'
and seqno = '291A0277'
group by [seimei] ,[seqno],[gwh]
两种办法,一种是先倒序排,然后limit 1,只取一条
另一种写个嵌套查询,内层先查最大的id号,外层根据id号查询