write a query to display to 10 max record from the employee
table?
Answers were Sorted based on User's Feedback
You are question is not clear.....you need decide based on
which column you want first 10 records.....
if you work on Salary column this is the query .......
select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/
Any queries on Sql please feel free to ask me i am very
interest in it......
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / srinu
select * from(select rownum r,emp.*from emp order by sal
desc) where r<=10;
Is This Answer Correct ? | 6 Yes | 2 No |
Answer / m m naidu
To display first 10 records we can write the query as
select * from(select * from emp order by ename desc) where
ronum<=10;
Is This Answer Correct ? | 7 Yes | 6 No |
Answer / lakhwinder singh
Query for display the top 10 records from the table(tbl1)
select top 10 * from tbl1
Is This Answer Correct ? | 4 Yes | 3 No |
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
write a query to display to 10 max record from the employee table?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
How u provide security to reports in report studio or in cognos connection?
Hi,please suggest me how to creat username while creating a report.
how you create security to cubes ?????
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
what are the special features in cognos reportnet?
what is the meaning of drill down and drill up in COGNOS 8BI