Home > Article > Backend Development > mysql 查询怎么写
mysql 查询怎么写
- WBOYOriginal
- 2016-06-23 14:15:39868browse
我想查询 相同vUserCode里的最新时间，
我自己写的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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：有谁给推荐个项目做？Next article：整合UCHOME到现有项目实现思路