Home/ Questions/Q 352046
Next
In Process
Trishana Satish Kumer
Asked: 2022-11-11T00:06:41+05:30 In:

Usage of aggregates in WHERE clause is allowed.

(a) True

(b) False

I had been asked this question in examination.

This intriguing question originated from Performing Multiple topic in division Using SQL to Manage Data of MySQL

Usage of aggregates in WHERE clause is allowed.

(a) True

(b) False

I had been asked this question in examination.

This intriguing question originated from Performing Multiple topic in division Using SQL to Manage Data of MySQL
Social
Leave an answer

Leave an answer

Browse

1 Answer

  1. Right option is (b) False

    The best explanation: The usage of aggregates inside ‘WHERE’ clauses is not allowed. For example, the following statement will not work : ‘SELECT * FROM my_table WHERE attribute_name = MAX(attribute_name)’, because the MAX value is not known yet.

    • 0