1,216
社区成员
发帖
与我相关
我的任务
分享
select a.*
From tb a ,(select 字段1,max(字段2) as 字段2 From tb Group by 字段1) b
where a.字段1=b.字段1 and a.字段2=b.字段2
select * from tb T where not exists(select 1 from tb where 字段2>T.字段2 and 字段1=T.字段1)
mysql> select a.* From a ,(select max(A2) as A2 From a Group by A1)b
-> where a.A2=b.A2;
+------+---------------------+---------------+
| A1 | A2 | A3 |
+------+---------------------+---------------+
| aaa | 2010-02-01 00:00:00 | a2222dddd |
| bbb | 2010-03-03 00:00:00 | bgbbhgdgdfgds |
+------+---------------------+---------------+
2 rows in set (0.00 sec)
select a.* From a ,(select max(A2) as A2 From a Group by A1)b
where a.A2=b.A2
select a.字段1, a.字段2, a.字段3
from my_table a
,(select 字段1, max(字段2) as 字段2
from my_table
group by 字段1
) b
where a.字段1 = b.字段1
and a.字段2 = b.字段2
select a.字段1, a.字段2, a.字段3
from my_table a
,(select 字段1, 字段2
from my_table
group by 字段1
) b
where a.字段1 = b.字段1
and a.字段2 = b.字段2