1.select * from tname where 列2-to_date('01-02-2002','dd-mm-yyyy')=
(select min(列2-to_date('01-02-2002','dd-mm-yyyy')) from tname)
2.select * from tname where (列1,列2)=(select 列1,max(列2) from tname group by 列1);
(select min(列2-to_date('01-02-2002','dd-mm-yyyy')) from tname)
2.select * from tname where (列1,列2)=(select 列1,max(列2) from tname group by 列1);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货