Thursday, February 11, 2010

Diff between intersect and innerjoin in SQL Server?

- Innerjoin gives duplicate rows where as intersect is not
- Innerjoin + distinct keyword = intersect

No comments:

Post a Comment