select * from ( select * from employee order by salary desc) where ro

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

Question Posted / phoebe

Answer Posted / phoebe

select * from
(
select * from employee
order by salary desc)
where rownum<11;

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Define dimensions?

1022

What is the size of database for you project?

1597

What is Fullouterjoin?

1983

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2317

What is set to be cardinality?

1174

Tell me about Dnamic and Static Dashboards?

2346

How do we convert from Numeric to be Words?

3021

Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.

1835

what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2320

Can you define drill down and drill up?

1034

Can you define report item?

1036

What do you understand by the term 'aggregate advisor?'

964

What are the main services provided by application tier?

981

9. What was the most complex type of report you dealt with?

2216

What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)

2138