[b]select TOP (522-513+1) ID ,[BL1QY] ,[BL2QY] ,COUNT(*)over(partition by [BL1QY],[BL2QY])as SAMEQY from [DLETou].[dbo].[10122 ] WHERE id NOT IN (SELECT TOP (513-1) id FROM [DLETou].[dbo].[10122 ] ) ORDER BY ID [1/b]
[b][1/b]select TOP (522-513+1) ID ,[BL1QY] ,[BL2QY] ,COUNT(*)over(partition by [BL1QY],[BL2QY])as SAMEQY from [DLETou].[dbo].[10122 ] WHERE id NOT IN (SELECT TOP (513-1) id FROM [DLETou].[dbo].[10122 ] ) ORDER BY ID [b] [1/b]
把你的SQL 放到这代码里面
,[BL1QY]
,[BL2QY]
,COUNT(*)over(partition by [BL1QY],[BL2QY])as SAMEQY
from [DLETou].[dbo].[10122 ]
WHERE id NOT IN (SELECT TOP (513-1) id FROM [DLETou].[dbo].[10122 ] )
ORDER BY ID
[1/b]
,[BL1QY]
,[BL2QY]
,COUNT(*)over(partition by [BL1QY],[BL2QY])as SAMEQY
from [DLETou].[dbo].[10122 ]
WHERE id NOT IN (SELECT TOP (513-1) id FROM [DLETou].[dbo].[10122 ] )
ORDER BY ID [b]
[1/b]
如
[code=SQL] 你的代码 [/code]
晕了
[code=SQL]
不能嵌套?[/code]
小小菜!!!!!!!!!!!!][/code]
加勒比小飞猪,下次谢谢你
select 加勒比小飞猪 FROM CSDN WHERE 加勒比小飞猪=谢谢你
??????没结果???
select 加勒比小飞猪 FROM CSDN WHERE 加勒比小飞猪=谢谢你
----执行结果
加勒比小飞猪=色狼
可怕......