SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?


 

 

 

 



A


Solution:-

The SQL UPDATE Statement
The UPDATE statement is used to modify particular existing records in a table.

UPDATE Syntax is given as follows:

UPDATE table_name SET columnA = valueA, columnB = valueB, columnC = valueC,... WHERE condition;

UPDATE Table
The following SQL statement updates the first admin (AdminID = 1) with a new admin and a new designation.

Example

UPDATE table_name SET columnA = valueA, columnB = valueB, columnC = valueC,... WHERE condition;

 




Next 5 multiple choice(s)

1

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

2

With SQL, how can you insert a new record into the "Persons" table?

3

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

4

Which SQL keyword is used to sort the result-set?

5

Which SQL statement is used to return only different values?

Comments