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 -~----------~----~----~----~------~----~------~--~---
