56,677
社区成员
发帖
与我相关
我的任务
分享
CRATE PROCEDURE PROC5(OUT A INT,OUT B INT)
BEGIN
DECLARE C INT;
DECLARE D INT;
SET A = (SELECT COUNT(ROOMCODE) FROM ROOM AS R,ROOMCLASS AS RC WHERE R.CLASSNO=RC.CLASSNO and CLASS='单人间');
SET B = (SELECT COUNT(ROOMCODE) FROM ROOM AS R,ROOMCLASS AS RC WHERE R.CLASSNO=RC.CLASSNO and CLASS='单人间' AND STATE='r');
SET C=(SELECT COUNT(ROOMCODE) FROM ROOM AS R,ROOMCLASS AS RC WHERE R.CLASSNO=RC.CLASSNO and CLASS='单人间' AND STATE='l');
SET D=(SELECT COUNT(ROOMCODE) FROM ROOM AS R,ROOMCLASS AS RC WHERE R.CLASSNO=RC.CLASSNO and CLASS='单人间' AND STATE='o');
SELECT A Z,B R,C L,D O;
END