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

What are the components of the report studio?

1111

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1877

how to perform single sign in cognos by using url?

1081

what are slowly changing dimensions? Why we are used scd?

1055

What is a Datastore in Cognos?

1225

hi my name is siraj i want to know cognos queriy language

2213

Can you define transformer?

893

What is the difference b/w macros and prompt?

1036

Define datastores in cognos?

885

What are the types of hierarchies?

968

What is the difference between regular dimension and derminant?

2195

How to deploy from one server to another server?

2431

----------------------What are the User Securities?

1796

What are the roles defined by cognos platform?

1073

What is model filter?

1104