INTERSECT
-
Comments posted to this topic are about the item INTERSECT
-
Prety easy question, a part of set theory (t1 n t2 n t3).
Thanks
-
The correct answer is that an error is returned as the columns are defined as "Id" and referenced as "ID"
-
Toreador (10/13/2015)
The correct answer is that an error is returned as the columns are defined as "Id" and referenced as "ID"Toreador!
Default collation is case insensitive.
-
Nice question, thanks. It's also a very efficient approach.
-
Very nice question. I hadn't had the chance to use this function yet and the question code was a quick way to play with it and add it to my toolbox.
-
Good demonstration. Too many folks don't realize that an INTERSECT is essentially like an INNER JOIN (or rather it's the other way around!).
LinkedIn: https://www.linkedin.com/in/sqlrv
Website: https://www.sqlrv.com -
Interesting one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Awesome, thanks for the question, I learned something from this:
I didn't realize you could DROP multiple tables with a single DROP statement (DROP TABLE #t1,#t2,#t3);
Rich
-
It is wrong to say that the answer is - nothing. It is also wrong to say, that a table is blank. It is - an empty table! Every select-statement returns a table, but the table can be empty. You will always get the column-names!
-
Nice question, Satish, thanks. It's good to know about INTERSECT; it's like an inner join, but with all of the columns automatically put into invisible ON clauses:
SELECT A.ID
FROM A
INNER JOIN B ON A.ID=B.ID
INNER JOIN C ON B.ID=C.ID
It's pretty simple with just one column, but with multiple columns, the equivalent ON clauses would get pretty long.
-
Almost got caught off guard with the blank third table.
-
Aaron N. Cutshall (10/13/2015)
Good demonstration.+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply