write a query to display to 10 max record from the employee
table?
- 8 Answers
- 10630 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / narender.v
select * from emp x where &n=(select count(distinct sal)
from emp y where x.sal<=y.sal)
it will prompt for the value give the values as 10 u will
get the output
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
----------------Describe DWH Architecture?
What is Additive function?
What is the use of powerplay web viewer in cognos?
Can you define a query subject?
Can you define framework manager?
What is called cognos reporting tool?
Give me any example of semi and non additive measures?
please please give me some banking calculations in framework manager.
Can you define drill down and drill up?
Name the types of gateway?
Define the slice and dice?
How can we create a dynamic column name in cognos?
What r the names of the reports that you prepared?
What are shortcuts? Where it can be used? What are the advantages?
What are the main services provided by application tier?
