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

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

Is This Answer Correct ?    754 Yes 97 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What has stored procedures in sql and how we can use it?

1013


What are the benefits of triggers?

1119


Can we use views in stored procedure?

967


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1976


What is a .db file?

925


How do I run a sql query in pgadmin 4?

904


What is sql and db2?

939


What is difference between cursor and trigger?

1015


How to sort the rows in sql.

1005


What makes a good primary key?

978


What is a temporal data type?

977


Can we use distinct and group by together?

989


What are conditional predicates?

986


Is there a 64 bit version of ssms?

893


What are the sql versions?

893