write a query to display the third record from the employee
table?
Answer Posted / srinu
select * from (select rownum r,emp.* from emp) where r=3;
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is the difference between a cascading report and drill through report?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
----------------Diff b/w Dimensional modeling and Relational modeling?
What do you understand by ‘ibm predictive maintenance and quality’?
All ready we have alias tables for modifications why we are using views if anybody this answer plz reply me
tell me two or three issues from client side and how to solve those issues?
What are the different types of reports present in cognos?
How we check the errors before running the report?
What r the names of the reports that you prepared?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What do you understand by the term 'model durability'?
Define cognos report net?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Can you define report item?