SELECT
*
FROM(
select
*
from tb_event_his
where (iSid, stDateTime) in (
select iSid, max(stDateTime) as stDateTime
from tb_event_his group by iSid
)
order by stDateTime desc
)t
group by t.iSid;
728x90
'Misc > DB' 카테고리의 다른 글
MariaDB 삭제 / 설치 (0) | 2023.02.17 |
---|