select rownum rn,(select e.* from emp e) order by sal desc where rn>=&

write a query to display to 10 max record from the employee
table?

Question Posted / madhusudhan

8 Answers
12928 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / madhusudhan

select rownum rn,(select e.* from emp e)
order by sal desc
where rn>=&rn;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a Framework manager?

1050

Can you define cube?

1035

hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1935

What is called a slice?

1033

What is a Pivot?

1154

Explain what is the difference between native sql and cognos sql?

1012

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2580

Mention the difference between ‘macros’ and ‘prompt’?

1148

what is stitch query in reportnet?

1105

What are the steps to import the two data sources in framework manager?

1048

Can we test the report other than manual testing?

2177

how u will design the report if the objects are available

2764

How to create a cube in Transformer? What is the process? Please mention process thank u

1766

Can you define snapshot?

927

Why are meta service important then other services?

974