SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?


 

 

 

 



B


Solution:-

The SQL WHERE Clause
The WHERE clause is used to filter records from a database table , the WHERE clause is used to extract only those records that fulfill a specified condition.

WHERE Syntax is as follows:
SELECT column1, column2, column3, ...FROM table_name WHERE condition;

WHERE Clause Example
The following SQL statement selects all the SlightBook Customers from the country "India", in the "CustomersBook" table:

An example is given below:
SELECT * FROM CustomersBook WHERE Country='India';

 




Next 5 multiple choice(s)

1

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

2

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

3

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

4

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

5

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

Comments