SQL實戰營Day 1

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