Network Group Lab 11 取出某個老師的課程? 使用join(inner join) ! SELECT C2.course_name FROM course AS C1, teacher_course AS C2 WHERE C2.teacher = ‘tom’ AND C1.name = C2.course_name
MAX(number) FROM course) OR SELECT name FROM course AS C1, (SELECT 高速網路實驗室 High Speed Network Group Lab 15 SELECT name FROM course AS C1, (SELECT MAX(number) AS max_number FROM course) AS C2 WHERE C1.number = C2.max_number 錯誤寫法 SELECT name FROM course WHERE number IN (SELECT MAX(number) FROM course)
High Speed Network Group Lab 23 索引對照的問題 Ex: primay key(name, property, online, number) SELECT * FROM course WHERE name = ‘a’ AND online = ‘y’ AND number = ‘5’
combined with ORDER BY When in disk? 高速網路實驗室 High Speed Network Group Lab 28 table include ‘BLOB’ or ‘TEXT’ any column in a GROUP BY or DISTINCT clause larger than 512 bytes