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 is sql server used?
How do I start sql server 2017?
Explain “row_number()” in sql server with an example?
Give a example to search fr a string in all stored procedure in sql server.
What is blocking?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
Explain about Joins?
How to populate a table in sql server?
How to Update from select query in sql server?
How connect excel to sql server?
What is openxml in sql server?
If no size is defined while creating the database, what size will the database have?
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)