小弟对sql不熟,求各位大侠指教
解决方案 »
- 求左连接优化代码
- oracle 错误 959 解决方法及疑问……
- 如何oracle 直接一起执行多条SQL语句
- ado连oracle,找了很久找不到解决办法
- Oracle数据库中的空与NULL的关系
- 请问远处数据链接的连接字符串怎样写?
- PLSQL中建database Link的问题
- 請問這樣的數據庫怎麼架設?
- 请教:操作系统崩溃后,如何恢复Oracle数据?
- 一个事务的简单问题。如何判断一条语句成功执行。
- 在linux企业版3下面安装oracle9i时遇到的问题--100分结帐
- 【请问】execute immediate ... 与不用execute immediate直接执行SQL语句有什么区别
cityname
from
(
select
a.city cityname,
count(a.city) city_cnt
from
city a
inner join
user b
on
a.id=b.usercity
group by
1
)
order by
city_cnt
where a.usercity = b.city
order by count_num
where a.usercity = b.city
group by b.city
from city a
inner join ( select usercity, count(id) AS idcount
from user
group by usercity) b
ON a.city = b.usercity
order by b.idcount desc;
select b.city,count(a.id) from user a ,city b
where a.usercity(+)=b.id
我觉的user表中的usercity与city表的id是城市的id 号吧,由于写的不明确,不知道如何关联了
select b.city,count(a.id) from user a ,city b
where a.usercity(+)=b.id
group by b.city
from city,
(select distinct first_value(user.usercity) over(order by count(user.id) desc)) usercity
from user
group by user.usercity) aa
where city.id = aa.usercity
如果usercity存放的是表city的id值就用上面的
如果usercity存放的是表city的city值就用下面的
select city.city
from city,
(select distinct first_value(user.usercity) over(order by count(user.id) desc)) usercity
from user
group by user.usercity) aa
where city.city = aa.usercity