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 / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax to add a record to a table?

1090


what are all the different normalizations? : Sql dba

1038


Is left join and outer join same?

1054


What is the use of function "module procedure" in pl/sql?

1192


how many sql dml commands are supported by 'mysql'? : Sql dba

1120


What is t sql in sql server?

1072


what is the command line end user interface - mysql? : Sql dba

981


What is the largest value that can be stored in a byte data field?

1012


Does postgresql run on the cloud?

1144


What is the difference between execution of triggers and stored procedures?

1115


Can we rollback after truncate?

1029


How many triggers can be applied to a table?

1058


Is primary key is clustered index?

1000


What is query optimization in sql?

983


Why use triggers in sql?

956