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 union transformation?
Explain what transformation and how many are there in informatica?
can anyone suggest best free Talend data integration training online
What is the maplet?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the tuning techniques you applied during your last project
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
Different circumstance which drives informatica server to expel records?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the types of presistent cache in look up tr.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Why is sorter an active transformation?
What is the benefit of partitioning a session?