how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / gyana
SELECT RN,EMPNO,ENAME,SAL FROM
(SELECT ROWNUM RN,EMPNO,ENAME,SAL FROM EMP)
WHERE RN IN (1,3,5)
---------------------------------------------------
I ALREADY TESTED ITS WORKING..PLS ANY CORRECTION LET ME KNOW
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is blocking transformation?
How do you promote a non-reusable transformation to reusable transformation?
What will be the approach?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is workflow manager?
What is flashback table ? Advance thanks
Explain lookup transformation is active in informatica
What is a router transformation?
Explain the scenario which compels informatica server to reject files?
define galaxy repository in informatica
What is different between the data warehouse and data mart?
Explain lookup transformation in informatica
What is native users?
What is a repository manager?
What is meant by a domain?