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 / hitesh pundir

select max(salary)from m1 where salary <>(select max(salary)
from m1)

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How long will it take to learn pl sql?

946


How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1099


How does stored procedure reduce network traffic?

1014


What is the non-clustered index in sql?

1067


Mention what plvcmt and plvrb does in pl/sql?

1144


What is substitution variable?

1056


Will truncate release space?

957


Enlist the data types that can be used in pl/sql?

1074


How to start oracle sql developer?

1046


Is left join same as inner join?

1137


What are the key differences between SQL and PL SQL?

1220


What is trigger and how to use it in sql?

1025


what are the advantages a stored procedure? : Sql dba

981


Explain the insert into statements in sql?

1010


how to present a past time in hours, minutes and seconds? : Sql dba

1015