COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which word allows you to add more than one filter to a SQL query?
|
|
AND
|
|
|
BETWEEN
|
|
|
LIKE
|
|
|
EQUALS
|
Explanation:
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. Let’s explore how to do this.
Detailed explanation-2: -FILTER is a modifier used on an aggregate function to limit the values used in an aggregation. All the columns in the select statement that aren’t aggregated should be specified in a GROUP BY clause in the query.
Detailed explanation-3: -Filtering is done on whole records, so conditions can use fields that are not actually displayed.
There is 1 question to complete.