What is Self Join?

Question Posted / ramesh

4 Answers
6718 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

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers

Can we check locks in database? If so, how can we do this lock check?

0 Answers

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers

How to create a new table in a given schema?

0 Answers

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers

How to generate create procedure script on an existing stored procedure?

0 Answers

Why are you getting errors when creating a new odbc dsn?

0 Answers

what does the automatic recovery do? : Sql server administration

0 Answers

what is statistics