what is use of self join and which cases you will use this join
Answer / vidhya
A physical file can be joined to itself to read records that are formed by combining two or more records from the PF itself.
You use a self join when a table references data in itself.
E.g., an Employee table may have a SupervisorID column that points to the employee that is the boss of the current employee.
To query the data and get information for both people in one row, you could self join like this:
e2.FirstName as SupervisorFirstName,
e2.LastName as SupervisorLastName
from Employee e1
left outer join Employee e2 on e1.SupervisorID = e2.EmployeeID
|Is This Answer Correct ?||0 Yes||0 No|
I had created one physical file tell me command to enter data in to?
Can anybody tell why Journalling is compulsary before Commitment Control?
How to index LF by relative record no (RRN)
If we use the file level keywords like LIFO, FIFO, FCFO in a file, can we see the impact of it by doing the run query of the file? if not how can we see the impact of these keywords.
what is the difference between adding keys & constraints into a phisical file
WHAT IS THE DIFFERENCE BETWEEN 'COLHDG' AND 'ALIAS'?
Why we create the Physical File Member?
How can we know that a trigger has been added on a PF? and what is the purpose of adding a trigger?
How to update physical file using logical file with example?
In a CL Program after executing a SQL SP how to receive a Output value from the SP. Just to make it clear I am sending 2 input and 1 output parameter to the SQL Stored Procedure. Now while receiving it output parm it is failing.
I have a PF with out any data but the dependent LF is having data?
pls anyone explain about compile time array,pre run time array run time array