What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain Dataware house architecture .how data flow from intial to end?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are connected or unconnected transformations?
What is persistent lookup cache?
Briefly describe lookup transformation?
Can you use flat files in Mapplets.
What is joiner transformation?
Enlist the differences between database and data warehouse.
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the difference between router and filter?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How many number of sessions can one group in batches?
What is the use of target designer?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Differentiate between joiner and lookup transformation?