Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7616 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 are the different type of replication in sql server?
What is a database table?
What is trace flag in sql server?
What is the difference between substr and charindex in the sql server?
What is 2nf normalization form?
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
what are default? Is there a column to which a default cant be bound?
What are the properties of sub-query?
What are different types of raid configurations? : SQL Server Architecture
What will be the maximum number of indexes per table?
Write down the syntax and an example for create, rename and delete index?
How is sql used in sql server?
-
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)
