write a query to display the third record from the employee
table?
Answer Posted / i.anil
select a.*,rownum from
(select b.*,rownum rk from
(select * from emp )b)a where rk=3;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What do you mean by drill through report?
how to merge 2 crosstabs thans
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
1. Explain your project.
Give me any example of semi and non additive measures?
what are the features in cognos8ui
what is catalog and types of catalogs in cagnos and which is better?
What are the different types of reports present in cognos?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
What is the importance of having monitor service in cognos?
How can I schedule reports in cognos?
please please give me some banking calculations in framework manager.
What is defined as data mining?