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

How can you view the errors encountered in a trigger?

917


How many types of cursors are available in pl/sql?

1045


Why truncate is faster than delete?

1055


What is indexing oracle sql?

1027


What is delimiter in pl sql?

993


What is trigger in sql?

1030


Why is the cursor important?

979


How do you bind variables in pl sql?

1036


What is the difference between explicit and implicit cursors in oracle?

999


Are stored procedures faster than queries?

901


What are all different types of collation sensitivity?

976


Do we need commit after truncate?

1034


what is user defined functions? : Sql dba

977


How do I sort a table in sql?

983


what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1006