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

Write types of folders present in cognos?

1127

How do you call a store procedure within a transformation?

1053

What are the components used in web tier?

1047

What is called cognos reporting tool?

1101

Can you define metrics designer?

1105

What is dtm?

1217

how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2464

How security is concerned with Reportnet? Explain its implementing steps.

2090

what are the names of the reports that you prepared?

1159

What are cognos connection initial page components?

1202

How can I schedule reports in cognos?

1060

Can you explain the advantage of using shortcuts?

1074

What do you mean by drill across?

1202

what is hints in cognos and where we use it.

2526

what is the difference between native sql and cognos sql?

1049