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 is the difference between undefined value and null value? : Sql dba

1101


What is acid property in a database?

1035


Explain ttitle and btitle.

1119


How do I view stored procedures?

975


What are joins in sql?

1044


What are predefined functions in sql?

1045


What is the difference between nvl function, ifnull function, and isnull function?

1113


Is sql free?

970


how to calculate expressions with sql statements? : Sql dba

1034


What is sql dialect?

1120


How sql query is executed?

1133


What is PL/SQL Records?

1190


What happens when a trigger is associated to a view?

915


Which sorts rows in sql?

1020


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209