34,587
社区成员
发帖
与我相关
我的任务
分享
SELECT BORROWID, STUDENTID,该学生借书的次数=COUNT(1) FROM TB GROUP BY BORROWID, STUDENTID
CREATE VIEW V_BOOK_STU
AS
SELECT
BORROWID,
STUDENTID,
(SELECT COUNT(1) FROM TB WHERE STUDENTID=T.STUDENTID)AS NUM
FROM TB T