月份动态?什么意思啊?select sum(decode(to_char(date_field,'mm'),'01',col_name)) 1月, sum(decode(to_char(date_field,'mm'),'02',col_name)) 2月, .... from table_name group by to_char(date_field,'mm');
如果你的sql是前端界面传入的,那么只要将sql语句拼出即可。 select * from tablename where to_char(date_field,'mm')=传入的值
我要查询5月的呢?
sum(decode(to_char(date_field,'mm'),'02',col_name)) 2月,
....
from table_name
group by to_char(date_field,'mm');
select * from tablename where to_char(date_field,'mm')=传入的值