how do u get the first record from 50,000 records ?

Answer Posted / amedela chandra sekhar

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the sql query overwrite in source qualifier in informatica

595


What is main use of mapplet?

627


What is the meaning of up gradation of repository?

1362


Explain sessions and how many types of sessions are there?

561


Quickly characterize reusable change?

658






Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

2404


What is the difference between router and filter?

627


What is informatica? Why do we need it?

612


Enlist the tasks for which source qualifier transformation is used.

564


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1444


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1656


Scheduling properties,whats the default (sequential)

1438


What all join we can perform in LOOKUP transformation?

535


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7736


What is the benefit of partitioning a session?

602