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

select max(sal) from emp where sal<any(select max(sal) from
emp)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how is myisam table stored? : Sql dba

1052


Which join condition can be specified using on clause?

952


What is the use of sqldataadapter?

967


what is a constraint? Tell me about its various levels. : Sql dba

983


What are packages in pl sql and also explain its advantages?

1028


How would you convert date into julian date format?

1000


Which is better join or subquery?

1133


What is the sql case statement?

998


How to run sql*plus commands in sql developer?

1150


What is the process of debugging?

1064


Can we use joins in subquery?

1158


What is embedded sql what are its advantages?

1032


What does select * from mean in sql?

3220


Is sql sequential or random?

1028


What is a pragma statement?

1262