Q4 You create a table called Games that contains review scores for recently released video games. You need to create a view that returns an alphabetical list of game titles. Name represents the game name. Which query should you use? A. CREATE VIEW MyGames AS SELECT Name FROM Games B. CREATE VIEW MyGames AS "SELECT * FROM Games C. CREATE VIEW MyGames AS SELECT Name FROM Games ORDER BY Name d. CREATE VIEW MyGames AS SELECT from Games | WHERE Name BETWEEN 'A' AND 'Z' ANS: C
您建立了一個名為 Games 的資料表,其中包含最近發行之電玩遊戲的評論分數。 您需要建立一個檢視表來傳回按照字母順序排列的遊戲名稱清單。 Name 代表遊戲名稱。 請問您應該使用哪一個查詢? A. CREATE VIEW MyGames AS SELECT Name FROM Games B. CREATE VIEW MyGames AS 「SELECT * FROM Games C. CREATE VIEW MyGames AS SELECT Name FROM Games ORDER BY Name D. CREATE VIEW MyGames AS SELECT from Games | WHERE Name BETWEEN 'A' AND 'Z' ANS: C
正確的查詢是C. CREATE VIEW MyGames AS SELECT Name FROM Games ORDER BY Name。
這個查詢會建立一個檢視表 MyGames，它只包含遊戲名稱並且按照字母順序排列。使用 "ORDER BY" 關鍵字會告訴資料庫對 "Name" 欄位進行排序，而 "SELECT" 關鍵字只會選擇 "Name" 欄位。因此，這個查詢可以幫助您快速地找到按字母順序排列的遊戲名稱清單。
🤯 做筆記才是看懂書的關鍵｜Notion 知識管理、閱讀筆記 （ Notion Book Library + Book Review Templates！）