select roomname,a.roomid,cnt
from (select roomid,count(count(*)) cnt from roominfo group by roomid) a,room b
where a.roomid=b.roomid;
from (select roomid,count(count(*)) cnt from roominfo group by roomid) a,room b
where a.roomid=b.roomid;
解决方案 »
- Warning: Procedure created with compilation errors
- system data oracleclient需要oracle客户端软件8.1 7或更高版本
- 如何利用IIS6.0 中的ODBC日志 在ORALCE里记录网站访问信息,高分求救
- imp导入
- 小弟是从MS-SQL才转到这里,还望各位大虾多多关照,只能放100分了,顺便问点弱智问题!
- 请教一个sql语句
- 前台调用存储过程如何返回执行的进度
- 如何把Oracle中Select出来的数据保存成mdb或文本文件(挥泪大送分)
- ************ORACLE超级难题***********************
- 数据库如何实现事物间数据完整性--求助帖
- 请问怎样得到刚插入记录的id值,其中我的id字段是自增的
- 真心求助:帮我解决长字符匹配数据库中的短字符
roomid integer,
roomname varchar2(10),
constraint pk_room primary key (roomid)
);create table roominfo(
roomid integer,
member_name varchar2(10),
constraint fk_roominfo foreign key (roomid) references room(roomid) on delete cascade
);begin
for x in 1..10 loop
insert into room values(x,'room'||x);
for y in 1..10 loop
insert into roominfo values(x,'name'||x||y);
end loop;
end loop;
commit;
end;
/select roomname,a.roomid,cnt
from (select roomid,count(*) cnt from roominfo group by roomid) a,room b
where a.roomid=b.roomid;
from qq_room s, roominfo t
where s.roomid=t.roomid
group by s.roomname,s.roomid 不过这样人数为0的房间未显示:如下则可
select s.roomname,s.roomid ,t.GustNum
from qq_room s, (select roomid,count(*) as GustNum from roominfo group by roomid) t
where s.roomid=t.roomid(+)