SQL Server ALL keyword

What is SELF JOIN and when would you use it?

A SELF JOIN is join which is used to join a table to itself.

There is no SELF JOIN keyword and it is used to compare values in a column with other values in the same column in the same table.

For Example,

SELECT * FROM TableA t1, TableA t2
WHERE t1.Id = t2.Id

In the above query, WHERE clause could be any given expression as per you!


I hope you are enjoying with this post! Please share with you friends!! Thank you!!!
ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.