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 most common sql injection tool?

1092


what are date and time intervals? : Sql dba

1105


What is pl sql record in oracle?

1090


What is a common use of group by in sql?

1097


How many types of triggers are there in pl sql?

1119


Which certification is best for sql?

1042


What are all the different normalizations?

1078


What is a pl/sql block?

1330


What are the two types of exceptions.

1222


what is data manipulation language? : Sql dba

1071


Explain 3 basic parts of a trigger.

1376


Explain polymorphism in pl/sql.

1171


explain advantages of innodb over myisam. : Sql dba

1176


Explain constraints in sql?

1088


What are the parts of a sql statement?

1147