create table t1 as
select '香蕉' prod_name,'20120102' end_date from dual union
select '香蕉','20120106' from dual union
select '橘子','20120205' from dual union
select '橘子','20120306' from dual union
select '苹果','20120501' from dual union
select '苹果','20120104' from dual union
select '鸭梨','20120208' from dual union
select '鸭梨','20120101' from dual想取其中prod_name 的最大end_date 也就是如下:香蕉 20120106
橘子 20120306
苹果 20120501
鸭梨 20120208首先我的这张表是千万级的,想问最优化的SQL语句。
select '香蕉' prod_name,'20120102' end_date from dual union
select '香蕉','20120106' from dual union
select '橘子','20120205' from dual union
select '橘子','20120306' from dual union
select '苹果','20120501' from dual union
select '苹果','20120104' from dual union
select '鸭梨','20120208' from dual union
select '鸭梨','20120101' from dual想取其中prod_name 的最大end_date 也就是如下:香蕉 20120106
橘子 20120306
苹果 20120501
鸭梨 20120208首先我的这张表是千万级的,想问最优化的SQL语句。
先跑跑试试~~~~
group by prod_name因为还有其他表要链接这个语句。现在感觉特别慢。