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 / parvezkhan pathan

select max(salary) from emp where salary not in(select
max(salary) 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 nested table and varray?

1006


What is rollback?

1118


Why is pl sql used?

987


What is the best partition size for windows 10?

1003


What is the syntax and use of the coalesce function?

1175


What is the most restrictive isolation level? : Transact sql

1085


Can cursors be part of a trigger body?

1641


what is collation? : Sql dba

1158


What is relationship? How many types of relationship are there?

1185


How are sql commands classified?

1092


What are the possible values that can be stored in a boolean data field?

1003


How do you rank data in sql?

1009


If a cursor is open, how can we find in a pl/sql block?

1167


Can we use pl sql in sql server?

1086


Is sql similar to python?

979