Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7611 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 normalization? Explain different forms of normalization?
Where are stored procedures in sql server?
how to improve the speed of SQL database server and how to avoid dead lock?
What are the difference between primary keys and foreign keys?
What is the use of =,==,=== operators?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
How to find the last update record in SQL Server?
plss anybody specify tha constrian management system in dbms
State a few properties of relational databases?
How can sql server instances be hidden?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
-
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)
