What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sbvp
select * from table name where sal in ( select * from
(select distinct sal from tablename order by sal desc)
where rownum<=&n);
if there is any another query plz tell me r mail me
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What is the use of transformation?
Write the prerequisite tasks to achieve the session partition?
how to create user defined function (udf) in informatica
Explain your project of banking domian.
what is the -ve test case in your project.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can a transformation be made reusable?
What do you understand by a term domain?
How can we use batches?
What is meant by pre and post session shell command?
Where are the source flat files kept before running the session?
How to load last n records of file into target table - informatica
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is unit testing?tell me proceedure