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

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Question Posted / shah.nawaz89

Answers were Sorted based on User's Feedback



Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / prashant

SELECT min(salary)
from emp
where salary in (select distinct top 5 salary from emp
order by salary desc)

Is This Answer Correct ?    1 Yes 3 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / vsandhyana

select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc

Thanks
Vikram Sandhyana

Is This Answer Correct ?    0 Yes 3 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / rakesh

select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5

Is This Answer Correct ?    3 Yes 7 No

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?..

Answer / pavan kumar

select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)

Is This Answer Correct ?    3 Yes 8 No

Post New Answer

More Cognos Interview Questions

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

What are all the types of hierarchies?

0 Answers  

write the sql query to display 5th and 10th row in a table?

5 Answers   CTS, IBM,

Can you define query studio?

0 Answers  

Please explain the different stages in creating a report in cognos report net?

0 Answers  

what is mean of Meta data definistions?

4 Answers   IBM,

How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.

5 Answers   HSBC,

What is Clipboard? How to import XML file into Clipboard?

2 Answers   CSC, HCL,

what is report view?

4 Answers   Cap Gemini,

is there any difference between operational database and data base?if yes what r they?

0 Answers  

What is the use of report studio?

0 Answers  

How do we create Links & Segments in Cognos Framework Manager?

1 Answers  

For more Cognos Interview Questions Click Here
Categories