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 read 2nd highest sal from EMP table?

Answer Posted / sasikala

select max(salary) from emp where salary<(select max(salary) from emp);

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we call future method from queueable?

1030


Explain few of the new features of sql server 2008 management studio

901


How do you manipulate data?

886


How to access the inserted record of an event?

1028


what are the different ways to return the rowcount of a table?

978


What are the different types of sub-queries?

1026


Can I work with several databases simultaneously? : sql server management studio

968


What is row_number () and partition by in sql server?

1053


Explain what is “asynchronous” communication in sql server service broker?

895


When to use null data driven subscription?

204


What is the difference between online clustering and Offline clustering?

2393


Why can there be only one clustered index and not more than one?

986


What are the different types of locks in the database?

910


What are the types of stored procedures in an sql server?

969


Explain the properties of the relational tables?

979