Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7539 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 |
what is victor class
What is the difference between constraints and triggers?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
What is data block and how to define data block size?
What are joins in sql and what are the different types of joins?
What are the steps to insert a table?
Benefits of Stored Procedures?
What are the magic tables in SQL Server 2000?
7 Answers Infogain, Merrill Lynch,
What are the recovery models for a database?
Which virtual table does a trigger use?
can you any body tell me the how to decrease the logfile
What is normalization? What number of normalization shapes are there?
-
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)
