SQL QUIZ
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
Structured Query Language
What does SQL stand for?
DELETE
Which SQL statement is used to delete data from a database?
SELECT
Which SQL statement is used to extract data from a database?
SELECT DISTINCT
Which SQL statement is used to return only different values?
INSERT INTO Persons (LastName) VALUES ('Olsen')
With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?
SELECT FirstName FROM Persons
With SQL, how do you select a column named "FirstName" from a table named "Persons"?
SELECT * FROM Persons
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'
With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE FirstName='Peter'
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?