Look at the below PLSQL join and select the type of join

select e.ename as employee
m.ename as manager
from employees m
JOIN
employees e
ON e.mgr = m.empno
where e.bdate > date '1965-01-01'
order by employee;

Options
- Self join
- Inner self join
- Self join on a table
- Outer self join

CORRECT ANSWER : Self join on a table

Discussion Board
Inner self join

Isn''t it INNER self join ?

Especially above Prajakta''s example IS INNER SELF JOIN, here you are:
SELECT a.column_name, b.column_name...
FROM table1 a, table1 b
WHERE a.common_field = b.common_field;



Marek 11-12-2020 10:05 AM

SELF JOIN on a Table

SELF JOIN simply is a normal join which is used to join a table to itself. There is no SELF JOIN keyword, you just write an ordinary join where both tables involved in the join are the same table.

Syntax:

SELECT a.column_name, b.column_name...
FROM table1 a, table1 b
WHERE a.common_field = b.common_field;

Here, WHERE clause could be any given expression based on your requirement.

Prajakta Pandit 02-14-2017 04:39 AM

oracle pl/sql

good

vivek 09-13-2014 12:14 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲