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 |
What is the partitioning method?
Explain optimistic and pessimistic concurrency?
What are the components of dbms?
optimization techinques
What are the instances when triggers are appropriate?
What is apply operator in sql?
What are the advantages of passing name-value pairs as parameters?
plss anybody specify tha constrian management system in dbms
How the data stores in a page?
What is the use of =,==,=== operators?
what is differece between union and union all
How do you fine the performance tunning?