MCQ IN COMPUTER SCIENCE & ENGINEERING

Previous
Next

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which word is missing from the following SQL statement?Select * from table ____ name where <condition> Having <condition>
A
With
B
Order by
C
Group by
D
IN
Explanation: 

Detailed explanation-1: -The HAVING Clause enables you to specify conditions that filter which group results appear in the results.

Detailed explanation-2: -Answer: C. A column alias cannot be used in WHERE clause conditions but can be used in SELECT statement and ORDER BY clause.

Detailed explanation-3: -We cannot use the HAVING clause without SELECT statement whereas the WHERE clause can be used with SELECT, UPDATE, DELETE, etc. WE can use aggregate functions like sum, min, max, avg, etc with the HAVING clause but they can never be used with WHERE clause .

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.

There is 1 question to complete.
Previous
Next