Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is Self Join?

Answers were Sorted based on User's Feedback



What is Self Join?..

Answer / ramesh

The Concept of joining a table with it self in called "self
join"

Is This Answer Correct ?    15 Yes 2 No

What is Self Join?..

Answer / shekar

the concept of joining a table with it self in called "self
join"

Is This Answer Correct ?    12 Yes 0 No

What is Self Join?..

Answer / rrrrrrrrrr

The Concept of joining a table with it self in called "self
join"

Is This Answer Correct ?    3 Yes 2 No

What is Self Join?..

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

Post New Answer



More SQL Server Interview Questions

Define ACID properties in a Database?

0 Answers   iNautix,


What are joins in sql and what are the different types of joins?

0 Answers  


What is the difference between the 2 operating modes of database mirroring?

0 Answers  


Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?

2 Answers  


Do you know the capabilities of cursors?

0 Answers  






What is sql server query analyzer?

0 Answers  


How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  


Explain indexes disadvantages?

0 Answers  


Where is my database stored on the hard disk in ms sql server?

0 Answers  


write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,


How do we get month name in SQL Server 2000, Oracle, MS Access?

11 Answers  


What is the difference between clustered and a non-clustered index?

0 Answers   NA,






Categories