select * from(select rownum r,emp.* from emp) where r=3;

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

Question Posted / srinu

4 Answers
8310 Views
HCL, I also Faced
E-Mail Answers

Answer Posted / srinu

select * from(select rownum r,emp.* from emp) where r=3;

Is This Answer Correct ?

6 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

4583

Explain the difference between native sql and cognos sql?

1021

hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

2129

How we check the errors before running the report?

1000

Can you define dimension?

1085

What is a Cube?

1148

What are the advantages of cognos?

979

Define cognos report net?

976

What is the use of powerhouse?

1086

Explain the difference between powerplay transformer and power play reports?

1025

What do you mean by drill across?

1148

Can you define transformer?

952

please please give me some banking calculations in framework manager.

2087

Define query studio?

1006

whats the difference between previous version of cognos and cognos 8 BI?

5532