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 do I view a sql database?

1023


What is coalesce sql?

1005


How delete all records from table in sql?

983


How exception is different from error?

1022


Why do we use cursors?

994


Does postgresql run on the cloud?

1154


what are numeric data types? : Sql dba

1065


Explain two easy sql optimizations.

1019


How to execute a stored procedure?

1098


How many types of triggers are there in pl sql?

1070


How do you modify a column in sql?

1002


What is the command used to fetch the first 5 characters of a string?

1212


Mention what is the plv (pl/vision) package offers?

1108


Which are sql * plus commands?

1132


What is the max nvarchar size?

985