摘要:
-- 方法1 select a.* from table1 a where not exists(select 1 from table1 b where b.name=a.name and b.gdtime>a.gdtime) -- 方法2 select a.* from table1 a inn 阅读全文
posted @ 2017-11-03 18:38 一佳一 阅读(852) 评论(0) 推荐(0)
|
||
|
摘要:
-- 方法1 select a.* from table1 a where not exists(select 1 from table1 b where b.name=a.name and b.gdtime>a.gdtime) -- 方法2 select a.* from table1 a inn 阅读全文
posted @ 2017-11-03 18:38 一佳一 阅读(852) 评论(0) 推荐(0) |
||