Re: HardCORE QUERY HELP!!! - Mailing list pgsql-sql

This is your prof speaking:
"DO YOUR OWN HOMEWORK YOU CHEATER!"

Seriously,

I'll give you a hint:
Try using
SELECT * FROM emp WHERE
(  sal >   (SELECT sal FROM emp AS EMP2      WHERE (EMP2.mgr=emp.mgr)) )

or something like that.
Use a ALIAS for the same table to distinguish them.

Hmm I am doing your homework.
Did I deserve a beer now?
;-)

Regards,
Erwin