English 中文(简体)
5. 数据的完整性
原标题:SQL query for data integrity

我有一个表格,其结构如下:

key1 varchar(255)
key2 varchar(255)
value decimal(6,2)

现在,我想收回所有按价值等于1000.00美元不变值的钥匙组合的胶卷。

有什么想法,我如何能够利用SQ做到这一点?

抽样数据

key1 key2  value
1    2     480
1    3     520
2    3     200
2    4     300
2    5     400

在这种情况下,我要问一下,最后3行将回来。

最佳回答
;WITH t
     AS (SELECT *,
                SUM(value) OVER (PARTITION BY key1) AS s
         FROM   yourtable)
SELECT key1,
       key2,
       value
FROM   t
WHERE  s <> 1000  
问题回答

暂无回答




相关问题
How to write this T-SQL WHERE condition?

I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...

Customer and Order Sql Statement

TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...

Recommended way of querying multiple Versioned tables

Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...

update duplicate record

I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...

Define variable to use with IN operator (T-SQL)

I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...

Selecting records during recursive stored procedure

I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...

热门标签