Interested to Buy Any Domain ? << Click Here >> for more details...
what is self join and how it works??
- 2 Answers
- 8554 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 |
What is constant in pl sql?
What are the different dml commands in sql?
What are the types of views in sql?
What is sqlite used for?
Can we call a function containing dml statements in a select query?
What is the use of count (*) in sql?
What is benefit of creating memory optimized table?
How to run sql statements through the web interface?
How you will create Toad Function?
how to use myisamchk to check or repair myisam tables? : Sql dba
What are the built in functions of sql?
what is online transaction processing (oltp)? : Sql dba
-
Oracle (3259) - 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)
