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 are the main services provided by application tier?
how can you get the errors in job? when loops are araised we get error?
How can I schedule reports in cognos?
What is the advantage of using shortcuts?
Define dimensions?
2. What functional area you worked on.
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is model?
Can you define fan trap?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
4. How many dimensions did you use in your reports?
What is defined as Cognos Impromptu?
whats the difference between previous version of cognos and cognos 8 BI?
What is the use of report studio?
what are the features in cognos8ui