Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7550 Views
- CarrizalSoft Technologies, HP, TCS, I also Faced
- E-Mail Answers
We use Self Join, if we have a table that references itself.
For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.
| Is This Answer Correct ? | 8 Yes | 0 No |
Is it ok to shrink transaction log?
How much memory that we are using in Logshipping Concept?
What is stretch database in sql server?
Can we use max in where clause?
What is a Join and explain its types?
Indexes are updated automatically is the full-text index also updated automatically?
What is the stuff?
What is the difference between cartesian product and cross join?
What are cursors and when they are useful?
Difeerence between ssis 2005 and ssis2008?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
What are examples of triggers?
-
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)
