What is Self Join?

Question Posted / ramesh

4 Answers
6614 Views
I also Faced
E-Mail Answers

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

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers Facebook,

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers

what is datawarehouse?

0 Answers Informatica,

what is performance tunning in sql server ? explain.

1 Answers Thomson Reuters,

how many bits ip address consist of? : Sql server database administration

0 Answers

What are user defined datatypes and when you should go for them?