What is Self Join?
Answers were Sorted based on User's Feedback
Answer / ramesh
The Concept of joining a table with it self in called "self
join"
| Is This Answer Correct ? | 15 Yes | 2 No |
Answer / shekar
the concept of joining a table with it self in called "self
join"
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / rrrrrrrrrr
The Concept of joining a table with it self in called "self
join"
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / gagan
Self join correlated rows of a table with other rows in the
same table.
Eg:
select a.name+'issue the book= '+b.book form lib a,lib b
where rollno between 1 and 10
| Is This Answer Correct ? | 1 Yes | 1 No |
Why union all is faster than union?
Describe in brief system database.
What are the steps need to be take improve the speed of a SQLDATA Server?
Wht is SQL Injection Attack ?
What are the instances when triggers are appropriate?
What are a scheduled jobs or what is a scheduled tasks?
How do I edit a procedure in sql server?
In what version of sql server were synonyms released?
What is Report Server,Report Manager and Report Builder in SSRS 2005?
How do database indexes work?
What is role playing dimension with two examples? : sql server analysis services, ssas
List out some of the requirements to set up a sql server failover cluster?
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)