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

select Max(salary) from test where salary not in(select Max
(salary) from test);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does postgresql compare to mysql?

987


Can you sum a count in sql?

955


Is pl sql and postgresql same?

1053


What is attribute indicator in pl sql?

959


what are dynamic queries in t-sql? : Transact sql

961


What are the different types of tables in sql?

929


What is the function that is used to transfer a pl/sql table log to a database table?

950


How to know the last executed procedure?

1032


How do I remove duplicates in two columns?

975


is mysql query is case sensitive? : Sql dba

1030


What are the types of queries in sql?

1015


What are the two types of periodical indexes?

886


What is the difference between local and global temporary table?

987


how to convert character strings to dates? : Sql dba

983


How you improve the performance of sql*loader? : aql loader

955