select NameCount,name (select count(name) NameCount,name from tableName where time between '2009-4-1' and '2009-4-30' group by name order by count(name) desc ) where rownum = 1
select name,max(count) count,time from table where time>=to_date('2009-4-1','yyyy-mm-dd') and time<=to_date('2009-4-30','yyyy-mm-dd') group by name,time
select 姓名 from ( select 姓名,sum(数量) from ttt2 where 时间 between to_date('2009-04-01','yyyy-mm-dd') and to_date('2009-04-30','yyyy-mm-dd') group by 姓名 order by sum(数量) desc) where rownum=1
谢谢大家,最终我发现这个可以: select name from ( select name from TEST where time between to_date('2009-04-01','yyyy-mm-dd') and to_date('2009-04-30','yyyy-mm-dd') group by name order by sum(value) desc ) where rownum=1 欢迎大家提出更好的解决方法
select NameCount,name
(select count(name) NameCount,name
from tableName
where time between '2009-4-1' and '2009-4-30'
group by name
order by count(name) desc
)
where rownum = 1
from table
where time>=to_date('2009-4-1','yyyy-mm-dd')
and time<=to_date('2009-4-30','yyyy-mm-dd')
group by name,time
from
(
select 姓名,sum(数量)
from ttt2
where 时间 between to_date('2009-04-01','yyyy-mm-dd') and to_date('2009-04-30','yyyy-mm-dd')
group by 姓名
order by sum(数量) desc) where rownum=1
select name
from
(
select name from TEST
where time between to_date('2009-04-01','yyyy-mm-dd') and to_date('2009-04-30','yyyy-mm-dd')
group by name
order by sum(value) desc
)
where rownum=1
欢迎大家提出更好的解决方法