[考題] 102年警察二等 資料庫
版上的各位好，我這邊有一題SQL查詢語法的問題，希望大家幫我看看我的觀念正不正確，
寫完沒正確解答可以對照總覺得不太穩，尤其是第(四)題，麻煩各位了，謝謝!
題目:
https://www.dropbox.com/s/t6utc5q266oxw5r/102_1.jpg
我的答案：
(一)
SELECT Car.CarNo, Car.Name, Car.Brand, Car.Model, Car.Color
FROM Car JOIN Speeding ON Car.CarNo = Speeding.CarNo
WHERE KM=63 AND Date BETWEEN '2013/4/1' AND '2013/4/15'
(二)
SELECT CarNo, Name, Brand, Model, Color, Engine
FROM Car
WHERE Name IN
(
SELECT Name
FROM Car
WHERE Engine > 3200
GROUP BY Name
HAVING COUNT(*) >= 2
)
(三)
SELECT Car.CarNo, Car.Name, Speed
FROM Car JOIN Speeding ON Car.CarNo = Speeding.CarNo
WHERE Speed >= ( SELECT MAX(Speed) FROM Speeding )
(四)
SELECT CarNo
FROM Car
WHERE NOT EXISTS
(
SELECT *
FROM ( SELECT * FROM Speeding GROUP BY Highway ) AS hw
WHERE NOT EXISTS
(
SELECT *
FROM Speeding
WHERE hw.Highway = Speeding.Highway AND
Car.CarNo = Speeding.CarNo
)
)
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 220.133.120.146
※ 文章網址: http://www.ptt.cc/bbs/Examination/M.1398407845.A.DF1.html
→
04/25 14:43, , 1F
04/25 14:43, 1F
→
04/25 14:43, , 2F
04/25 14:43, 2F
→
04/25 14:49, , 3F
04/25 14:49, 3F
→
04/25 14:50, , 4F
04/25 14:50, 4F
→
04/25 14:51, , 5F
04/25 14:51, 5F
→
04/25 14:51, , 6F
04/25 14:51, 6F
→
04/25 14:52, , 7F
04/25 14:52, 7F
→
04/25 14:52, , 8F
04/25 14:52, 8F
※ 編輯: lordfish62 (220.133.120.146), 04/25/2014 14:55:36
※ 編輯: lordfish62 (220.133.120.146), 04/25/2014 14:56:48
→
04/25 14:56, , 9F
04/25 14:56, 9F
→
04/25 14:59, , 10F
04/25 14:59, 10F
※ 編輯: lordfish62 (220.133.120.146), 04/25/2014 15:01:00
→
04/25 15:05, , 11F
04/25 15:05, 11F
→
04/25 15:05, , 12F
04/25 15:05, 12F
Examination 近期熱門文章
PTT職涯區 即時熱門文章