views:

1070

answers:

2

I'm fully aware that set division can be accomplished through a series of other operations, so my question is:

Is there a command for set division in SQL?

+2  A: 

http://vadimtropashko.files.wordpress.com/2007/02/ch3.pdf

From Page 32:

Relational Division is not a fundamental operator. It can be expressed in terms of projection, Cartesian product, and set difference.

So, no. :)

Brad Wilson
+2  A: 

Related question: http://stackoverflow.com/questions/48475/database-design-for-tagging

And relevant part of answer is this article

So in short, no, there is no set division in SQL.

Slartibartfast