From: Erwin Moller <erwin@_removespam_dexus.nl>
To: pgsql-sql@postgresql.org
Subject: Re: HardCORE QUERY HELP!!!
Date: Mon, 03 Mar 2003 19:24:15 +0100
Message-ID: <3E639DCF.9000705@_removespam_dexus.nl> (raw)
References: <hOednbvBOI8QG_yjXTWcqQ@giganews.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: erwin@_removespam_dexus.nl
Subject: Re: HardCORE QUERY HELP!!!
In-Reply-To: <3E639DCF.9000705@_removespam_dexus.nl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox