ansaurus

Question

having condition on result of a subquery in mysql

Answer 1

+2 A:

It's so in MS SQL, so I assume, that the same problem is in MySQL.

Try to change WHERE to HAVING. WHERE clause doesn't see your renamed columns.

HAVING is working the same way as WHERE, like (mycol < 400 AND a > 5).

GROUP BY should be before HAVING.

Check the examples in the link.

http://www.databasejournal.com/features/mysql/article.php/3469351/The-HAVING-and-GROUP-BY-SQL-clauses.htm

hgulyan 2010-05-13 07:10:06

thanks but sorry i forgot to mention that i am also using a group by clause in this query which seems to break the having thing. And what would be the syntax ifthere are multiple conditions to be checked with having ?

naiquevin 2010-05-13 07:19:45

I've edited my answer. If it's what you wanted, just mark it as answer.

hgulyan 2010-05-13 07:24:43

thanks this worked in a small sample query, will check if it does in the bigger one in a while. Thanks a lot.

naiquevin 2010-05-13 07:30:33

and don't forget to mark it as answer. Do this in your other questions, if you got the answer.

hgulyan 2010-05-13 07:34:37

ok will do it but a bit confused . i clicked on the green tick icon alongside this answer. I guess that does it.

naiquevin 2010-05-13 07:41:36

Yeah, it is. Also you can vote up an answer (or anything else) if you find it useful. Read the faq:)http://stackoverflow.com/faq

hgulyan 2010-05-13 07:48:24

ansaurus

tags:

views:

answers:

having condition on result of a subquery in mysql

related questions