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 / gurvinder

select max(sal)from emp where sal in(select sal from emp minus select max(sal) from emp);

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 postgresql users are there, worldwide?

994


How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158


What is nosql db?

926


What is pl sql block structure?

975


What are the different datatypes available in PL/SQL?

1029


What is difference between rank () row_number () and dense_rank () in sql?

1052


how to create a new table by selecting rows from another table in mysql? : Sql dba

1011


What are sql queries used for?

981


How do I write a sql query in pgadmin 4?

927


Explain spool.

1113


Is sql easier than java?

947


How to know the last executed procedure?

1035


is mysql query is case sensitive? : Sql dba

1031


How many types of tables are there?

901


How do you update sql?

915