Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find the n'th highest salary from emp ?

Answer Posted / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to build data dictionary view an new database?

958


What is a proxy object?

1008


Write a trigger example in oracle?

980


How to create a new table in your schema?

1028


how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

1948


How to get maxsal , minsal, ename department wise in single query

1499


Can you drop an index associated with a unique or primary key constraint?

967


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2151


Difference between varchar and varchar2 data types?

1115


What is the difference between $oracle_base and $oracle_home?

1027


What is the difference between substr & instr functions?

1120


List the various oracle database objects?

994


How to view existing locks on the database?

994


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2198


How to create a new oracle data file?

969