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 / kameshwar shukla(a.i.e.t l.k.o

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

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 delete and truncate commands?

1100


What is clustered index sql?

1031


What is parameter substitution in sql?

1081


what are string data types? : Sql dba

1093


how to drop an existing index in mysql? : Sql dba

1114


What is example of database?

1135


what is the difference between sql and t-sql? : Transact sql

1136


what are the authentication modes in sql server? How can it be changed? : Sql dba

1514


What are the different schemas objects that can be created using pl/sql?

1085


what is the difference between nested subquery and correlated subquery?

1094


What is data modelling in sql?

1077


Explain alias in sql?

1095


Mention what pl/sql package consists of?

1045


What's the difference between a primary key and a clustered index?

1029


Explain raise_application_error.

1145