write a query to display the third record from the employee
table?
Answer Posted / j
select * from emp e where 3=(select count(sal) from emp
where e.sal>sal)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
------------ Diff b/w MemberCaption and MemberDescription?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
what is the difference between native sql and cognos sql?
How is possible this scenario using in type-in prompt.?
how to explain health care project and which reports we can create in health care doain?
What do you understand by the term 'aggregate cache'?
How to create model and how to test model?
What is a Framework manager?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
what is online view?
What is the advantage of using shortcuts?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
Can you define a catalog and types of catalogs in cognos?
What is looping and how to avoid it in framework manager?