COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
And
|
|
|
Maybe
|
|
|
If
|
|
|
Or
|
Detailed explanation-1: -You can use the AND condition in the WHERE clause to specify more than 1 condition that must be met for the record to be selected.
Detailed explanation-2: -The WHERE clause allows us to set the conditions by which rows are fetched from data tables. A condition is some kind of expression that evaluates to either true or false.
Detailed explanation-3: -Filtering is done on whole records, so conditions can use fields that are not actually displayed.
Detailed explanation-4: -SQL filters are text strings that you use to specify a subset of the data items in an internal or SQL database data type. For SQL database and internal data types, the filter is an SQL WHERE clause that provides a set of comparisons that must be true in order for a data item to be returned.