从无到有

我本将心向明月,奈何明月照沟渠

导航

temp

--方法一:
Select * from TEST A
Where (Select SUM(bonus) from TEST Where id<=A.id)<1000
And (Select SUM(bonus) from TEST Where id<=A.id+1)>=1000
--方法二:
Select Top 1 A.id from TEST A
Where (Select SUM(bonus) from TEST Where id<=A.id)<1000
Order By id Desc
--方法三:
Select Top 1 A.id-1 As id from TEST A
Where (Select SUM(bonus) from TEST Where id<=A.id)>=1000
Order By id

SELECT MAX(id) AS id
FROM (SELECT a.id
        FROM test a, test b
        WHERE a.id >= b.id
        GROUP BY a.id
        HAVING SUM(b.bonus) < 1000) c

select A.* from stu A where not exists(select 1 from stu where cid=A.cid and score>A.score having count(*)>1)

Create Table TEST1
(a Int)
Insert TEST1 Values(2)
Insert TEST1 Values(3)
Insert TEST1 Values(5)
Insert TEST1 Values(5)
Insert TEST1 Values(5)
Insert TEST1 Values(4)
Insert TEST1 Values(4)
Insert TEST1 Values(4)
Insert TEST1 Values(2)

 


select mobile from t7 where mobile not in (select mobile from t7 where state='北京' )
select mobile from t7 a where not exists (select mobile from t7 b where state='北京' and a.mobile=b.mobile)

USE Northwind
GO
SELECT CategoryName FROM Categories WHERE EXISTS (SELECT NULL) ORDER BY CategoryName ASC
GO

posted on 2005-07-13 16:54  从无到有.NET  阅读(434)  评论(0)    收藏  举报