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

find out the third highest salary?

Answer Posted / mohd. rashid

SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain what are synonyms used for?

1034


How to generate query output in html format?

1116


How to increment dates by 1 in oracle?

1079


What are a query and state the different types of queries and their uses?

1012


Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2007


What is data file?

1101


What is the data type of dual table?

991


How to create a stored procedure in oracle?

1102


What happens in oracle commit?

1024


Is java required for oracle client?

996


What is a view and how is it different from a table?

1044


Explain a segment?

1083


How to insert multiple rows with one insert statement in oracle?

1083


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1931


How to define an external table with a text file?

1063