Can we specify aggregate operators in WHERE cluase

Question

SQL Queries aggregate operators

Answer 1

Can you elaborate further on your goal and the idea behind the use of aggregate operator in WHERE clause?

Answer 2

MIN,MAX,COUNT,AVG,SUM are aggregate operators

Answer 3

Yes I know that too, I mean what are you trying to achieve by using any of those? can you tell me that please?

Answer 4

SELECT name FROM sailors WHERE age = MIN(age)

Does that make sense?

Answer 5

Yes you wrote in correct way

Answer 6

Find the name of youngest sailor

Answer 7

Ipang maybe it is dependent on the SQL engine, but I think "WHERE age = MIN(age)" woul not work properly. I would expect it to require a subselect:

WHERE age = (SELECT Min(age) FROM sailors)

Answer 8

In WHERE class by using other query we specify the aggregate operators