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

Answer Posted / phoebe

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

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4075


What is the size of the cube?

531


Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

1867


What are the batches and it’s details?

562


what is a prompt value in report studio and variables ?

2160






can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com

1701


What errors and types of errors you faced in Cognos ReportNet?

3478


What is a Framework manager?

557


What is difference between informatica power mart and power center?

558


can you tell me what are the dimension tables are used in project

1884


Explain informatica architecture?

549


What is difference between content store and content manager?

540


How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..

1551


Explain is there any comparison available for cognos reportnet vs crystal reports?

536


What is the difference between a cascading report and drill through the report?

725