write the sql query to display 5th and 10th row in a table?
- 5 Answers
- 15362 Views
- CTS, IBM, I also Faced
- E-Mail Answers
Answer Posted / kart
select * from (select rownum as rn,aone.* from aone)
where rn in(5,10);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
------------- How to identify the Revenue Column in Report?
whats the difference between previous version of cognos and cognos 8 BI?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can you define dimension?
what is online view?
Can you define query studio?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
What is a Datastore in Cognos?
What is the difference between a cascading report and drill through report?
9. What was the most complex type of report you dealt with?
Can you define drill down and drill up?
Can you define metrics designer?
Define the slice and dice?
What is difference between informatica power mart and power center?
