Re: Sql Query

From: Steve Long <steve-long_at_mediaone.net>
Date: Wed, 10 Oct 2001 07:05:24 GMT
Message-ID: <UqSw7.1378$Ry.8902_at_typhoon.jacksonville.mediaone.net>


you should learn to do your own homework. otherwise, you are cheating yourself and your peers. this will catch up to you and bite you in the a** one day.

"gaurav aggarwal" <gauravaggarwal_82_at_hotmail.com> wrote in message news:be43ce54.0110092216.46033a7b_at_posting.google.com...
> hello!
> i used the following query for getting the second highest earner in the
 emp table.
> select * from emp e where 1=(select count(*) from emp where e.sal<sal);
> can someone explain to me the working of the query
Received on Wed Oct 10 2001 - 09:05:24 CEST

Original text of this message