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 second highest salary from emp table?

Answer Posted / yash goyal

Select Distinct salary
from employees e
where &no-1=(select count(distinct salary )
from employees
where E.salary < salary);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of triggers exist in pl/sql?

1134


Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1149


Why do we use set serveroutput on?

1014


How to select all records from the table?

1181


What is query optimization in sql?

1043


How to take user input in pl sql?

1204


what is a composite key ? : Sql dba

1101


What is Collation Sensitivity ? What are the various type ?

1001


List out the acid properties and explain?

1018


how to write date and time literals? : Sql dba

1010


What is dbo in sql?

1019


What is the purpose of cursors in pl/sql?

1201


how to check server status with 'mysqladmin'? : Sql dba

1132


How many commands are there in sql?

1087


What is coalesce in sql?

1131