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

Find out the 3rd highest salary?

Answer Posted / jeevitha

select distinct a.salfrom emp a where &n= (select count
(distinct(b.sal)from emp b where a.sal<= b.sal)
-----
enter the highest sal of n:2,3.....n

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you sort in sql?

951


what is the difference between delete and truncate commands? : Sql dba

995


What is meant by <> in sql?

893


Explain sql data types?

1035


What jobs use sql?

925


What is attribute indicator in pl sql?

959


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1039


What is primary key and unique key?

1049


How do I run a sql query in pgadmin 4?

905


what is isam? : Sql dba

951


what is error ora-03113: end-of-file on communication channel?

1081


Explain how to use transactions efficiently : transact sql

923


what are myisam tables? : Sql dba

951


what are the join types in tsql? : Transact sql

981


What is the purpose of my sql?

900