阅读背景:

用于选择包含所有一组值的组的SQL语句

来源:互联网 

In SQL Server 2005, I have an order details table with an order id and a product id. I want to write a sql statement that finds all orders that have all the items within a particular order. So, if order 5 has items 1, 2, and 3, I would want all other orders that also have 1, 2, and 3. Also, if order 5 had 2 twice and 3 once, I'd want all other orders with two 2s and a 3.In SQL Server 2005, I have an order details tab




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: