select a.*,rownum from (select b.*,rownum rk from (select * from emp )b)

write a query to display the third record from the employee
table?

Question Posted / i.anil

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

Please Help Members By Posting Answers For Below Questions

Can you explain a cognos controller?

595

------------------What is Inline Query?

1782

What is called materialized view?

585

please please give me some banking calculations in framework manager.

1646

what is the procedure for scheduling conditional rendering?

1993

What is a Pivot?

535

Write some methods to apply securities in framework manager model?

646

What do you understand by the term 'aggregate advisor?'

534

-----------With out using DrillThrough how to do Reports?

1593

What is model filter?

620

What are the ways to import data into catalog?

625

What is a Datastore in Cognos?

788

what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

2535

What is called a slice?

566

Cleared COG-112 with 100% score today. What next certification should i go for?

1409