Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 7 Answers
- 13732 Views
- HCL, I also Faced
- E-Mail Answers
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 is a box type in cognos? what is a stitch query? what are the services that run in background when cognos is running
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith
Define metrics studio?
What is defined as catalog and types of catalogs in Cognos?
How to pass parameter value into html design page? (That is YOU Create a html page and use that page in your cognos 8 report header.take <html item> my question is how to use parameter value in the html page .)
What is the difference between a cascading report and drill through the report?
I would appreciate if any one answer for this, I have faced the question like this, the question was Tell me some complex reports, which u faced?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
What is the difference between macro & Parameter
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Teradata 
