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 |
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
How to automatically create a log when an exception is being received into SQL Server?
Which are new data types introduced in sql server 2008?
How retrieve field names from the table in SQL through JAVA code?
How to encrypt data between dialogs?
How to declare and use cursor variables?
What is coalesce and check constraint in sql server?
what is a transaction and what are acid properties? : Sql server database administration
can a table be moved to different filegroup? : Sql server administration
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
What is difference between restoration and recovery in SQLServer?
Can we perform backup restore operation on tempdb? : sql server database administration
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)