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

select slary from emp order by slary desc limit 1,1;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does <> sql mean?

1084


What are % type and % rowtype?

1028


what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

949


Which one is better subquery or joins?

1058


How is data stored on a disk?

1026


what is a view? : Sql dba

1081


How do I audit the sql sent to the server?

1004


Can we enter data in a table in design view?

967


Explain the components of sql?

1057


Explain aggregate functions are available there in sql?

1003


What is sqlca in powerbuilder?

1004


How to display the records between two range in Oracle SQL Plus?

1145


Explain the steps needed to create the scheduled job?

1036


Explain the commit statement.

1153


what is offset-fetch filter in tsql? : Transact sql

945