資料庫期末題庫

Strong Question Language

Structured Question Language

Structured Query Language

Strong Query Language

UPDATE

SAVE

SELECT

MODIFY

ADD NEW

INSERT NEW

INSERT INTO

ADD RECORD

EXTRACT FirstName FROM Persons

SELECT FirstName FROM Persons

SELECT Persons.FirstName

EXTRACT Persons.FirstName

SELECT Persons

SELECT *.Persons

SELECT [all] FROM Persons

SELECT * FROM Persons

SELECT * FROM Persons WHERE FirstName LIKE'％a'

SELECT * FROM Persons WHERE FirstName ='％a％'

SELECT * FROM Persons WHERE FirstName ='a'

SELECT * FROM Persons WHERE FirstName LIKE'a％'

SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND

'Pet-tersen'

SELECT * FROM Persons WHERE LastName>'Hansen' AND Last-Name<'Pettersen'

SELECT * FROM Persons WHERE FirstName BETWEEN 'Hansen' AND

'Pet-tersen'

SELECT DISTINCT

SELECT DIFFERENT

SELECT SAME

SELECT DIFFERENCE

SORT

ORDER

ORDER BY

SORT BY

INSERT

('Jimmy', 'Jackson')

INTO Persons

INSERT VALUES ('Jimmy', 'Jackson')

INTO Persons

INSERT INTO VALUES

('Persons ', 'Jimmy',

'Jackson')

INSERT INTO Persons VALUES ('Jimmy', 'Jackson')