select
a.number
from
(select number,count(id) as counts group by number) a
where
rownum < 2
order by
a.counts desc
a.number
from
(select number,count(id) as counts group by number) a
where
rownum < 2
order by
a.counts desc
解决方案 »
- Oracle中的存储过程,如何获取到游标的长度?
- 结果集比较
- oracle-pc where 中条件字段名过多错
- 关于不安装客户端的问题
- 关于return的作用
- linux下安装oracle9i时出现乱码
- 在oracle中,有没有类似SQL中的通配符?
- 急请教PROCEDURE高手,在Object Browser里,我这个PROCEDURE为何总是建立不成?
- 安装oracle碰到这种错误,咋办
- 50分求助:连接oracle的javabean中用stmt = conn.createStatement();没问题。用stmt = conn.createStatement(java.sql.ResultSet.TYPE_SC
- 再问备分
- 先update,成功后再insert, 如何在sql语句中实现?
from
(
select count(number),number
from table
group by number
order by count(number) desc
)
where rownum<2
(
select num from tb
group by num
having count(*)=(
select max(count(*)) from tb group by num
)
)
/
---------- ----------
1 10
3 10