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...

Write a query to find second highest salary of an employee.

Answer Posted / akilis.org@hotmail.com

Let us assume that
Table Name:salary
Coloumn Name:maxsal(int)
select * from salary order by maxsal desc limit 1,1;

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many sql commands are there?

1102


What is sqlcommand?

1013


What is a memo field?

948


What are pl/sql cursor exceptions?

1078


explain the advantages and disadvantages of stored procedure? : Sql dba

992


Can we create clustered index without primary key?

948


Why we use stored procedure instead of query?

984


What is sql procedures and functions?

994


What is insert command in sql?

1108


How do you change a value in sql?

1002


What are sql data types?

1003


What is a natural join sql?

956


explain about mysql and its features. : Sql dba

1004


How exception is different from error?

1004


What is the non-clustered index in sql?

1052