write the sql query to display 5th and 10th row in a table?
Answer Posted / gautam ramteke
select *
from(select rt.*,rownum r from (select * from gpr_employee
order by hire_date)rt)
where r in (5,8);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the difference between list report and crosstab report?
What are cognos connection initial page components?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What is cognos powerhouse?
What are all the types of report?
What is the difference between drill through, drill across?
how u will determine the performence tune will occur either in report or system
where you can save the report net documentation in our local system?
what is the difference between filter and condition?
Name the types of report?
What is meant by alternate drill down with ex?
What are the ways to import data into catalog?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
-----------Diff b/w OLAP and RDBMS?