?? quary6.sql
字號:
SELECT information.fname as "First Name", information.lname as "Last Name", information.memno as "ID",COUNT(information.memno)
FROM (
SELECT fname , lname, memno
FROM member LEFT JOIN book ON (member.memno = book.borrowermemno)
) AS information
GROUP BY information.memno,information.fname,information.lname
HAVING COUNT(information.memno) > 3
ORDER BY COUNT(information.memno) DESC
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -