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 / syed hussain

select min(salary) from tbl_emp where salary in
(select top 4 salary from Tbl_emp order by salary desc)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are properties of the transaction?

998


What is the sql case statement?

1000


Why coalesce is used in sql?

1005


What is the difference between view and stored procedure?

959


What are the types of dbms?

971


What is sqlite format?

1191


How long will it take to learn pl sql?

935


How do I install microsoft sql?

1049


What does (*) mean in sql?

948


what is an index? : Sql dba

991


How do you take the union of two tables in sql?

982


What are types of joins?

963


What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1096


What does a pl/sql package consist of?

972


What is rollback?

1110