mysql 查询怎么写
程序员文章站
2022-06-17 15:40:13
...
我想查询 相同vUserCode里的最新时间,
我自己写的sql 语句,select * from table group by vUserCode order by cDate desc
我自己写的sql 语句,select * from table group by vUserCode order by cDate desc
回复讨论(解决方案)
select * from (select * from table order by cDate desc) t group by vUserCode
select max(cDate) from table group by vUserCode