MySQL获取最新一条记录

* FROM table_name AS ta WHERE ta.唯一键 = ( SELECT max ( tb.唯一键 ) FROM table_name AS tb WHERE ta.判断重复的列 = tb.判断重复的列 );

方法二：

 select   b. *   from  ( select  a. *   from  tableA a  order   by  a.create_time  desc ) tableB b  group   by  b.判断重复的列;

 

MySQL获取最新一条记录

标签：获取   nbsp   group   max   rgb   判断   create   div   esc   

查看更多关于MySQL获取最新一条记录的详细内容...