One small amendment:
select * from
(
select emp_id, ename, sal, rownum r_num
from emp_master e
join sal_master s on s.emp_id = e.emp_id
ORDER BY SAL,emp_id
)
where r_num = 3;
If there are ties, you will get the one with the smallest emp_id.
On Tue, Aug 4, 2009 at 9:56 AM, Michael Moore <[email protected]>wrote:
> select * from
> (
> select emp_id, ename, sal, rownum r_num
> from emp_master e
> join sal_master s on s.emp_id = e.emp_id
> )
> where r_num = 3;
>
>
>
> On Mon, Aug 3, 2009 at 9:51 PM, Harry79 <[email protected]> wrote:
>
>>
>> Hello i do have one problem with SQL Query.
>> There are total two table and i would like to get 3rd highest salary.
>>
>> Table 1: emp_master
>> Column : ename,emp_id
>>
>> Table 2: Sal_master
>> Column : sal,emp_id
>>
>> So how can i get the third highest salary?
>> emp_id is PK
>>
>> >>
>>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
