如果一个表中有compid字段,该字段为某个用户所发布的所有信息。
如今要取得其中最新的一条信息,则语法如下:
select * from mytable where id in ( select max(id) from mytable group by compid having count(*)>1 )
如今要取得其中最新的一条信息,则语法如下:
select * from mytable where id in ( select max(id) from mytable group by compid having count(*)>1 )