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 / pankaj raj patel

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how tsql statements can be written and submitted to the database engine? : Transact sql

922


Why do we use sql constraints? Which constraints we can use while creating database in sql?

972


What is memory optimized?

1009


What are transaction and its controls?

967


what is a database transaction? : Sql dba

1106


What is sql injection owasp?

999


Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1176


What do you know by pl/sql cursors?

1035


What is a left join?

889


What are sql built in functions?

894


how to create a test table in your mysql server? : Sql dba

943


What are the features of pl sql?

1013


Explain the the update statement in sql?

987


What is join view in sql?

897


What is time based sql injection?

901