SQL QUIZ

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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"?


Kaugnay na mga set ng pag-aaral

Chapter 18 motor learning: Whole and Part Practice

View Set

Telencephalon, Limbic System, Diencephalon

View Set

Ch. 68 Neurologic Trauma Practice Questions

View Set

Geometry B, Assignment 12. Circles: Area of Sectors

View Set