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 cognos connection?
What are all the types of indexes in Cognos?
where you can save the report net documentation in our local system?
How do you call a store procedure within a transformation?
How we check the errors before running the report?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
How is cognos model organization works?
-----------------What is Determination Model?
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.
Can you define a query subject?
What is the difference between set functions and filter function in dimensional data?
how to explain health care project and which reports we can create in health care doain?
Explain informatica architecture?
What is difference between content store and content manager?
What are various types of gateways in cognos?