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 for the fifth highest salary?

Answer Posted / nitin bisht

SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When should you not use firebase?

1062


You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1224


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3090


What is the purpose of firebase?

973


List the properties of a transaction.

1055


Is it good to store images in database?

1000


what are wrappers and build ups and what it's use?

2158


What is a reference table in database?

1022


What is the Difference Primary key and Unique Key

999


What is dialect in database?

971


I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1550


What is ole db provider for sql server?

1029


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

1470


What is sharded database?

954


How many types of locks are present in a database?

1127