第二页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 12 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
第三页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 24 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 12 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
第三页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 24 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
解决方案 »
- 如何用sql语句列出 两记录相加等于90的所有数据呢?
- 没有诸存过程,很简单的问题。
- 会SQL的都来看看,在线等待,急用!
- sql server2000企业管理打不开是什么原因
- 关于SQL SERVER数据库的超莱问题?
- VFP的GRID问题...
- 请问在企业管理器中连接服务器,总是提示“无效的属性/选项标示符”导致无法连接,如何解决?
- SQL SERVER 7是否必须装在win2k的server或advanced版本上?
- 超难问题:这个存储过程怎么写?
- 关于特字字符替换的问题
- sql_server 2K 附加数据库问题请教
- 图例中各项以及横轴上各项的顺序问题。在报表中无法解决,现在想在查询中解决
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 0 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
第二页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 12 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
第三页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 24 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001')
第一页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and and PClassID='00001')
order by PID
第二页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 12 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL) order by PID) and PClassID='00001')
order by PID
第三页
SELECT TOP 12 PID, A0101 FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL)) and PClassID='00001' and PID not in (SELECT TOP 24 PID FROM A01 where (B0002 like '01%' or (B0001='01' and B0002 is NULL) order by PID) and PClassID='00001')
order by PID