Interested to Buy Any Domain ? << Click Here >> for more details...
what is self join and how it works??
- 2 Answers
- 8630 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / alok kumar samartha
The concept of joining a table with itself is called self
join or inner join.It works based on the provided join condition
example:-select e1.empno employee,e2.ename manager from emp
e1,emp e2 where e2.empno=e1.mgr;
| Is This Answer Correct ? | 3 Yes | 4 No |
How do you bind variables in pl sql?
Define concurrency control. : Transact sql
How do I view a table in sql?
what is a stored procedure? : Sql dba
how to load data files into tables with 'mysqlimport'? : Sql dba
how to rename an existing column in a table? : Sql dba
How many types of keys are there in sql?
How do I access sql anywhere database?
Are stored procedures faster than dynamic sql?
Define join and name different types of joins?
What is the difference between SQL and PLSQL
Enlist the characteristics of pl/sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
