Structured Query Language
SELECT
UPDATE
DELETE
INSERT INTO
SELECT FirstName FROM Persons
SELECT * FROM Persons
SELECT * FROM Persons WHERE FirstName='Peter'
错误答案:SELECT * FROM Persons WHERE FirstName='a'
正确答案:SELECT * FROM Persons WHERE FirstName LIKE 'a%'
正确
错误答案:SELECT * FROM Persons WHERE FirstName LIKE 'Thomas' AND LastName LIKE 'Carter'
正确答案:SELECT * FROM Persons WHERE FirstName='Thomas' AND LastName='Carter'
错误答案:SELECT * FROM Persons WHERE LastName>'Adams' AND LastName<'Carter'
正确答案:SELECT * FROM Persons WHERE LastName BETWEEN 'Adams' AND 'Carter'
13.哪条 SQL 语句可返回唯一不同的值?
错误答案:SELECT UNIQUE正确答案:SELECT DISTINCT
ORDER BY
错误答案:SELECT * FROM Persons ORDER FirstName DESC
正确答案:SELECT * FROM Persons ORDER BY FirstName DESC
错误答案:INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
正确答案:INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
错误答案:INSERT ('Wilson') INTO Persons (LastName)
正确答案:INSERT INTO Persons (LastName) VALUES ('Wilson')
错误答案:UPDATE Persons SET LastName='Wilson' INTO LastName='Gates'
正确答案:UPDATE Persons SET LastName='Wilson' WHERE LastName='Gates'
DELETE FROM Persons WHERE FirstName = 'Fred'
SELECT COUNT(*) FROM Persons