NEW
Font size
WorksheetsSQL實戰營Day 1
Total questions: 10
Worksheet time: 5mins
SQL的全名是?
Strong Question Language
Structured Question Language
Structured Query Language
哪個SQL語法是用來拉從資料庫抓取數據?
SELECT
GET
OPEN
EXTRACT
使用SQL時, 要怎麼抓取一個資料行名稱為"FirstName" ，從 "Persons"的資料表?
SELECT FirstName FROM Persons
SELECT Persons.FirstName
EXTRACT FirstName FROM Persons
使用SQL時, 您要怎麼選取所有資料行從"Persons"的資料表?
SELECT [all] FROM Persons
SELECT Persons
SELECT *.Persons
SELECT * FROM Persons
使用SQL時,你要怎麼從 "Persons" 的資料表選擇 "FirstName" 是 "Peter" 的資料列?
SELECT [all] FROM Persons WHERE FirstName=’Peter’
SELECT* FROM Persons WHERE FirstName<>’Peter’
SELECT* FROM Persons WHERE FirstName=’Peter’
SELECT [all] FROM Persons WHERE FirstName LIKE ’Peter’
使用SQL時,你要怎麼從 "Persons" 的資料表選擇 "FirstName" 開頭是 "a" 的資料列?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT* FROM Persons WHERE FirstName LIKE ’a%’
SELECT* FROM Persons WHERE FirstName= Like’ % a’
SELECT* FROM Persons WHERE FirstName= Like’ % a%’
OR 運算符號是如果有其中一項條件有滿足，就會顯示出所有的資料列。AND運算符號是如果兩項條件都有被滿足，才會顯示資料列。
是
否
使用SQL時,您要怎麼從"Persons"的資料表抓出 "FirstName"是"Peter"且"LastName"是 "Jackson"資料列?
SELECT FirstName=’Peter’, LastName=’Jackson’ FROM Persons
SELECT * FROM Persons Where FirstName<>’Peter’ AND LastName<>’Jackson’
SELECT * FROM Persons Where FirstName=’Peter’ AND LastName=’Jackson’
哪個SQL語法用於返回唯一不同的值?
SELECT DISTINCT
SELECT DIFFERENT
SELECT UNIQUE
哪個SQL語法是用在排序資料?
SORT BY
ORDER BY
ORDER
SORT
