Interview Preparation mode beta
Funny Facebook Status Funny Facebook Status
Enter your email address

What is a self-join, in MS SQL Server?

Nice?Vote!
asked 1 year ago in SQL Server Interview Questions and Answers by R (19,530 points) edited 1 year ago by R

1 Answer

Nice?Vote!
self join is join the table to itself.
ex: select col1,col2 from tbl a inner join tbl b on a.col1=b.col2
there is only one table called in the above query tbl
answered 3 months ago by anonymous

Related questions