Ashqar Khan's Profile

About

 
Points: 3

Contact

 

Drop files in here
or click to pick manually
Ashqar Khan  >>  Bucky Roberts
March 7, 2016 · Public

Hey Bucky

In your MySQL tutorial 18 you have showed that where clause can be used with aggregate functions but on other sites it is mentioned that WHERE clause cannot be used with the aggregate functions directly but as a sub-query .

HELP ME OUT.

Link: http://stackoverflow.com/questions/6319183/aggregate-function-in-sql-where-clause

Ashqar Khan
March 6, 2016 · Public

hey Bucky in your MySQL tutorial 18 you have showed us that WHERE clause is used with aggregate functions but on every SQL site it is written that WHERE clause cannot be used with the aggregate functions .

And on this site it is mentioned that we can use where clause with aggeregate functions as a sub-query
http://stackoverflow.com/questions/6319183/aggregate-function-in-sql-where-clause

please help me out .