SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER BY sal desc)

How to list Top 10 salary, without using Rank Transmission?

Question Posted / chinthi

Answer Posted / chinthi

SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does command task mean?

1062

What is meant by query override?

1005

whats the logic to load the lower level of granularity of data to fact table.

2206

what are factless facts? And in which scenario will you use such kinds of fact tables.

1740

What are the new features of informatica 9.x developer?

900

What are the main issues while working with flat files as source and as targets ?

1096

Which version configuration tool used in ur project?

3181

What are the transformations that are not supported in mapplet?

955

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2389

What all join we can perform in LOOKUP transformation?

913

What is blocking transformation?

1082

What is the benefit of partitioning a session?

1102

Explain what are the different types of transformation available in informatica.

1038

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

965

permutations of mapplet

2454