COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Table ____ name
|
|
|
WHERE
|
|
|
LIKE
|
|
|
Database name
|
Detailed explanation-1: -The WHERE clause, if given, indicates the condition or conditions that rows must satisfy to be selected. where condition is an expression that evaluates to true for each row to be selected. The statement selects all rows if there is no WHERE clause.
Detailed explanation-2: -The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables.
Detailed explanation-3: -The WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition.
Detailed explanation-4: -In a SQL statement, the WHERE clause specifies criteria that field values must meet for the records that contain the values to be included in the query results.
Detailed explanation-5: -Where in SQL is used to filter records on the basis of a condition, or it is used to extract records which satisfy a condition. In this example, we want to extract those records where the age of a person is more than fifty or sixty out of those records where the occupation of the person is a doctor.