select * from emp where rownum<4 minus select * from emp where rownum&l

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

Question Posted / kumar

Answer Posted / kumar

select * from emp where rownum<4 minus select * from emp
where rownum<3;

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the ways to import data into catalog?

1033

How Metrics Studio is better than Report Studio?

2521

what is log in cognos?

1148

----------------Describe DWH Architecture?

2020

Explain what is the difference between microstrategy and cognos reporting tool?

1009

What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?

2094

what is power prompt in cognos ep7series?what is the use of this?

3637

What are all the advantages of Cognos?

986

hi my name is siraj i want to know cognos queriy language

2220

Can you define report item?

994

what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)

2038

What is the difference between the standard and metrics folder?

914

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1017

--------------Explain Table of contents?

1980

How to create a cube in Transformer? What is the process? Please mention process thank u

1709