Sql Query
From: gaurav aggarwal <gauravaggarwal_82_at_hotmail.com>
Date: 9 Oct 2001 23:16:02 -0700
Message-ID: <be43ce54.0110092216.46033a7b_at_posting.google.com>
Date: 9 Oct 2001 23:16:02 -0700
Message-ID: <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 - 08:16:02 CEST