Slightbook.com Slightbook.com

SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL
Prev
Next     Others

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?


 

 

 

 



C


Solution:-

The SQL SELECT Statement is used to select data from a database table.

SELECT Syntax 

SELECT column1, column2, column3,...FROM table_name;

Here, column1, column2, column3,... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the below syntax:

SELECT * FROM table_name;

SELECT Column Example is as follows:
SQL statement selects the "CourseName" and "Duration" columns from the "Slightbook" table:

SELECT CourseName, Duration FROM Slightbook;

 



Prev
Next     Others

Next 5 multiple choice(s)

1

With SQL, how do you select all the columns from a table named "Persons"?
2

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
3

Which SQL statement is used to insert new data in a database?
4

Which SQL statement is used to delete data from a database?
5

Which SQL statement is used to update data in a database?

Comments