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

It works gr8...

select max(salary) from <table_name> where salary<(select
max(salary)from <table_name>)

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to install oracle sql developer?

1056


What is the location of pre_defined_functions.

1166


what are the differences between require and include, include_once and require_once? : Sql dba

1029


can a stored procedure call itself or recursive stored procedure? : Sql dba

1037


What are all ddl commands?

1089


What is schema in sql example?

1186


What is a memo field?

972


How many sql statements are used?

1018


What are the benefits of triggers?

1175


How do you respond to dementia behavior?

974


Explain what is a column in a table?

1113


What is cte?

986


How do you get column names only for a table (sql server)?

1170


What is data manipulation language?

1193


Is mariadb nosql?

1045