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 find out the list schema name and table name for the database?
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
What are the different types of subquery?
What is policy based management (pbm)? : sql server database administration
Mention the differences between local and global temporary tables.
How to execute a sql statement using mssql_query()?
how to do partition in sqlserver
How do you delete a data source?
How to update muliple row in single query?
What is partitioned view?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
What does the on delete cascade option do?
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)