write the sql query to display 5th and 10th row in a table?
Answer Posted / lakshmi reddy
select * from(select emp.*,rownum r from emp) where r=5 or r=10
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
--------------Diff b/w ODS and OLAP?
Give the advantages of cognos?
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..
------------- How to identify the Revenue Column in Report?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
What is a Framework manager?
What are the batches and it’s details?
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What is the difference between set functions and filter function in dimensional data?
can we insert all types of charts in a list report? what r the realtime prompts?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What are the two types of framework manager?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
How do we convert from Numeric to be Words?
-------------What is Coditional Prompting?