select * from emp e where 4=(select count(sal) from emp where e.sal>sa

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

Question Posted / ammu

Answer Posted / ammu

select * from emp e where 4=(select count(sal) from emp
where e.sal>sal)

Because it follows n-1 rule..

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to create cubes in transformer ?

1071

Define query items?

1013

What is a dimension?

1026

Can you define transformer?

948

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

2270

What do you understand by user class in cognos?

950

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

1762

4. How many dimensions did you use in your reports?

1951

What is the model filter?

1010

What you mean by drill across?

1017

dumps needed ASAP for - C2020-180 Cognos IBM Certification

2203

Explain the different types of views used in cognos.

942

Define olap designer?

1127

what is the main advantage of impromptu over cognos reportnet?

1035

Name the types of report?

950