温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
阅读(2727)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'谈谈HINT　/*+parallel(t,4)*/在SQL调优中的重要作用',
blogAbstract:'/*+parallel(t,4)*/在大表查询等操作中能够起到良好的效果,基于并行查询要启动并行进程、分配任务与系统资源、合并结果集，这些都是比较消耗资源,但我们为能够减少执行事务的时间使用parallel HINT还是值得的,尤其在ODS系统中报表统计等方面更有使用意义.一般而言主要在如下情况使用parallel HINT1.表的数据量很大,超过一千万; 2.数据库主机是多个CPU;3.系统的当前负载较低;简单的测试如下,效果很明显的:SQL& select /*+parallel(t,4)*/count(*) from& &t;&&COUNT(*)----------&&已用时间:&&00: 01: 32.04',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:0,
publishTime:1,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:1,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
hmcon:'1',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}热门搜索：　 　 　 　 　
mysql查询[select * from user limit 0, 10;]
来源：未知
时间： 09:56
作者：xxadmin
[导读] 只适用于MySQL. 请参考下面资料。限制结果集行数 在进行数据检索的时候有时候需要只检索结果集中的部分行，比如说检索成绩排前三名的学生、检索工资水平排在第3位到第7位的员工信...
只适用于MySQL.
请参考下面资料。
限制结果集行数
在进行数据检索的时候有时候需要只检索结果集中的部分行，比如说&检索成绩排前三名的学生&、&检索工资水平排在第3位到第7位的员工信息&，这种功能被称为&限制结果集行数&。在虽然主流的数据库系统中都提供了限制结果集行数的方法，但是无论是语法还是使用方式都存在着很大的差异，即使是同一个数据库系统的不同版本（比如MSSQLServer2000和MSSQLServer2005）也存在着一定的差异。因此本节将按照数据库系统来讲解每种数据库系统对限制结果集行数的特性支持。
MYSQL中提供了LIMIT关键字用来限制返回的结果集，LIMIT放在SELECT语句的最后位置，语法为&LIMIT 首行行号，要返回的结果集的最大数目&。比如下面的SQL语句将返回按照工资降序排列的从第二行开始（行号从0开始）的最多五条记录：
SELECT * FROM T_Employee ORDER BY FSalary DESC LIMIT 2,5
返回按照工资降序排列的前五条记录
SELECT * FROM T_Employee ORDER BY FSalary DESC LIMIT 0,5
MS SQLServer2000
MSSQLServer2000中提供了TOP关键字用来返回结果集中的前N条记录，其语法为&SELECT TOP 限制结果集数目 字段列表 SELECT语句其余部分&，比如下面的SQL语句用来检索工资水平排在前五位（按照工资从高到低）的员工信息：
select top 5 * from T_Employee order by FSalary Desc
实现检索按照工资从高到低排序检索从第六名开始一共三个人的信息，那么就可以首先将前五名的主键取出来，在检索的时候检索排除了这五名员工的前三个人，SQL如下：
SELECT top 3 * FROM T_Employee
WHERE FNumber NOT IN
(SELECT TOP 5 FNumber FROM T_Employee ORDER BY FSalary DESC)
ORDER BY FSalary DESC
MS SQLServer2005
MSSQLServer2005兼容几乎所有的MSSQLServer2000的语法，所以可以使用上个小节提到的方式来在MSSQLServer2005中实现限制结果集行数，不过MSSQLServer2005提供了新的特性来帮助更好的限制结果集行数的功能，这个新特性就是窗口函数ROW_NUMBER()。ROW_NUMBER()不能用在WHERE语句中。
ROW_NUMBER()函数可以计算每一行数据在结果集中的行号（从1开始计数），其使用语法如下：
ROW_NUMBER OVER(排序规则)
比如我们执行下面的SQL语句：
SELECT ROW_NUMBER() OVER(ORDER BY FSalary),FNumber,FName,FSalary,FAge
FROM T_Employee
返回第3行到第5行的数据
SELECT * FROM
SELECT ROW_NUMBER() OVER(ORDER BY FSalary DESC) AS rownum,
FNumber,FName,FSalary,FAge FROM T_Employee
WHERE a.rownum&=3 AND a.rownum&=5
Oracle中支持窗口函数ROW_NUMBER()，其用法和MSSQLServer2005中相同.
注意：rownum在Oracle中为保留字，所以这里将MSSQLServer2005中用到的rownum替换为row_num；Oracle中定义表别名的时候不能使用AS关键字，所以这里也去掉了AS。
在Oracle中可以无需自行计算行号，Oracle为每个结果集都增加了一个默认的表示行号的列，这个列的名称为rownum
SELECT rownum,FNumber,FName,FSalary,FAge FROM T_Employee
得到按工资从高到底排序的前6名员工的信息
SELECT * FROM T_Employee
WHERE rownum&=6
ORDER BY FSalary Desc
DB2中支持窗口函数ROW_NUMBER()，其用法和MSSQLServer2005以及Oracle中相同.
，DB2还提供了FETCH关键字用来提取结果集的前N行，其语法为&FETCH FIRST 条数 ROWS ONLY&，比如我们执行下面的SQL语句可以得到按工资从高到底排序的前6名员工的信息：需要注意的是FETCH子句要放到ORDER BY语句的后面
SELECT * FROM T_Employee
ORDER BY FSalary Desc
FETCH FIRST 6 ROWS ONLY
检索按照工资从高到低排序检索从第六名开始一共三个人的信息，那么就可以首先将前五名的主键取出来，在检索的时候检索排除了这五名员工的前三个人，SQL如下：
SELECT * FROM T_Employee
WHERE FNumber NOT IN
SELECT FNumber FROM T_Employee
ORDER BY FSalary DESC
FETCH FIRST 5 ROWS ONLY
ORDER BY FSalary DESC
FETCH FIRST 3 ROWS ONLY
抑制数据重复 DISTINCT
DISTINCT关键字是用来进行重复数据抑制的最简单的功能，而且所有的数据库系统都支持DISTINCT，DISTINCT的使用也非常简单，只要在SELECT之后增加DISTINCT即可. DISTINCT是对整个结果集进行数据重复抑制的.
SELECT DISTINCT FDepartment,FSubCompany FROM T_Employee
上一篇： 下一篇：
更多文章推荐
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FF
<span style="display: padding-left:5 font-size:12 color:#FForacle维护常用sql
1、查看表空间的名称及大小select t.tablespace_name, round(sum(bytes/()),0) ts_sizefrom dba_tablespaces t, dba_data_files dwhere t.tablespace_name = d.tablespace_namegroup by t.tablespace_2、查看表空间物理文件的名称及大小select tablespace_name, file_id, file_name,round(bytes/(),0) total_spacefrom dba_data_filesorder by tablespace_3、查看回滚段名称及大小select segment_name, tablespace_name, r.status,(initial_extent/1024) InitialExtent,(next_extent/1024) NextExtent,max_extents, v.curext CurExtentFrom dba_rollback_segs r, v$rollstat vWhere r.segment_id = v.usn(+)order by segment_4、查看控制文件select name from v$5、查看日志文件select member from v$6、查看表空间的使用情况select sum(bytes)/() as free_space,tablespace_namefrom dba_free_spacegroup by tablespace_SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,(B.BYTES*100)/A.BYTES "% USED",(C.BYTES*100)/A.BYTES "% FREE"FROM SYS.SM$TS_AVAIL A,SYS.SM$TS_USED B,SYS.SM$TS_FREE CWHERE A.TABLESPACE_NAME=B.TABLESPACE_NAME AND A.TABLESPACE_NAME=C.TABLESPACE_NAME;7、查看数据库库对象select owner, object_type, status, count(*) count# from all_objects group by owner, object_type,8、查看数据库的版本　Select version FROM Product_component_versionWhere SUBSTR(PRODUCT,1,6)='Oracle';9、查看数据库的创建日期和归档方式Select Created, Log_Mode, Log_Mode From V$D10、如何远程判断Oracle数据库的安装平台select * from v$11、查看数据表的参数信息SELECT partition_name, high_value, high_value_length, tablespace_name,pct_free, pct_used, ini_trans, max_trans, initial_extent,next_extent, min_extent, max_extent, pct_increase, FREELISTS,freelist_groups, LOGGING, BUFFER_POOL, num_rows, blocks,empty_blocks, avg_space, chain_cnt, avg_row_len, sample_size,last_analyzedFROM dba_tab_partitions--WHERE table_name = :tname AND table_owner = :townerORDER BY partition_position12、查看还没提交的事务select * from v$locked_select * from v$14、回滚段查看select rownum, sys.dba_rollback_segs.segment_name Name, v$rollstat.extentsExtents, v$rollstat.rssize Size_in_Bytes, v$rollstat.xacts XActs,v$rollstat.gets Gets, v$rollstat.waits Waits, v$rollstat.writes Writes,sys.dba_rollback_segs.status status from v$rollstat, sys.dba_rollback_segs,v$rollname where v$rollname.name(+) = sys.dba_rollback_segs.segment_name andv$rollstat.usn (+) = v$rollname.usn order by rownum15、捕捉运行很久的SQLcolumn username format a12column opname format a16column progress format a8select username,sid,opname,&&&&& round(sofar*100 / totalwork,0) || '%' as progress,&&&&& time_remaining,sql_textfrom v$session_longops , v$sqlwhere time_remaining && 0and sql_address = addressand sql_hash_value = hash_value/16。查看数据表的参数信息SELECT&& partition_name, high_value, high_value_length, tablespace_name,&&&&&&& pct_free, pct_used, ini_trans, max_trans, initial_extent,&&&&&&& next_extent, min_extent, max_extent, pct_increase, FREELISTS,&&&&&&& freelist_groups, LOGGING, BUFFER_POOL, num_rows, blocks,&&&&&&& empty_blocks, avg_space, chain_cnt, avg_row_len, sample_size,&&&&&&& last_analyzed&& FROM dba_tab_partitions--WHERE table_name = :tname AND table_owner = :townerORDER BY partition_position17。查找object为哪些进程所用selectp.spid,s.sid,s.serial# serial_num,s.username user_name,a.type object_type,s.osuser os_user_name,a.owner,a.object object_name,decode(sign(48 - command),1,to_char(command), 'Action Code #' || to_char(command) ) action,p.program oracle_process,s.terminal terminal,s.program program,s.status session_statusfrom v$session s, v$access a, v$process pwhere s.paddr = p.addr and&&&& s.type = 'USER' and& &&&& a.sid = s.sid&& anda.object='SUBSCRIBER_ATTR'order by s.username, s.osuser18。耗资源的进程（top session）select s.schemaname schema_name,&&& decode(sign(48 - command), 1,to_char(command), 'Action Code #' || to_char(command) ) action,&&& statussession_status,&& s.osuser os_user_name,&& s.sid,&&&&&&&& p.spid ,&&&&&&&& s.serial# serial_num,nvl(s.username, '[Oracle process]') user_name,&& s.terminal terminal,& s.program program,&& st.value criteria_value from v$sesstat st,&& v$session s , v$process pwhere st.sid = s.sid and&& st.statistic# = to_number('38') and&& ('ALL' = 'ALL'or s.status = 'ALL') and p.addr = s.paddr order by st.value desc, p.spid asc, s.username asc, s.osuser asc19。查看锁（lock）情况select /*+ RULE */ ls.osuser os_user_name,&& ls.username user_name,decode(ls.type, 'RW', 'Row wait enqueue lock', 'TM', 'DML enqueue lock', 'TX','Transaction enqueue lock', 'UL', 'User supplied lock') lock_type,o.object_name object,&& decode(ls.lmode, 1, null, 2, 'Row Share', 3,'Row Exclusive', 4, 'Share', 5, 'Share Row Exclusive', 6, 'Exclusive', null)lock_mode,&&& o.owner,&& ls.sid,&& ls.serial# serial_num,&& ls.id1,&& ls.id2& from sys.dba_objects o, (&& select s.osuser,&&& s.username,&&& l.type,& l.lmode,&&& s.sid,&&& s.serial#,&&& l.id1,&&& l.id2&& from v$session s,& v$lock l&& where s.sid = l.sid ) ls where o.object_id = ls.id1 and&&& o.owner&& 'SYS'&& order by o.owner, o.object_name根据sid查是哪台电脑的链接column osuser format a15column username format a10column machine format a30select osuser,machine,username,sid,serial# from v$session where sid='128';根据sid查对应的sqlselect SID,SQL_TEXT from v$open_cursor where SID='128';20。查看等待（wait）情况SELECT v$waitstat.class, v$waitstat.count count, SUM(v$sysstat.value) sum_valueFROM v$waitstat, v$sysstat WHERE v$sysstat.name IN ('db block gets','consistent gets') group by v$waitstat.class, v$waitstat.count21。查看sga情况SELECT NAME, BYTES FROM SYS.V_$SGASTAT ORDER BY NAME ASC22。查看catched objectSELECT owner,&&&&&&&&&&&&& name,&&&&&&&&&&&&& db_link,&&&&&&&&&&&&& namespace,&&&&&&&&&& type,&&&&&&&&&&&&& sharable_mem,&&&&&&&&&&&&& loads,&&&&&&&&&&&&& executions,&&&&&&&&& locks,&&&&&&&&&&&&& pins,&&&&&&&&&&&&& kept&&&&&&& FROM v$db_object_cache&&&&&& 23。查看V$SQLAREASELECT SQL_TEXT, SHARABLE_MEM, PERSISTENT_MEM, RUNTIME_MEM, SORTS,VERSION_COUNT, LOADED_VERSIONS, OPEN_VERSIONS, USERS_OPENING, EXECUTIONS,USERS_EXECUTING, LOADS, FIRST_LOAD_TIME, INVALIDATIONS, PARSE_CALLS, DISK_READS,BUFFER_GETS, ROWS_PROCESSED FROM V$SQLAREA24。查看object分类数量select decode (o.type#,1,'INDEX' , 2,'TABLE' , 3 , 'CLUSTER' , 4, 'VIEW' , 5 ,'SYNONYM' , 6 , 'SEQUENCE' , 'OTHER' ) object_type , count(*) quantity fromsys.obj$ o where o.type# & 1 group by decode (o.type#,1,'INDEX' , 2,'TABLE' , 3, 'CLUSTER' , 4, 'VIEW' , 5 , 'SYNONYM' , 6 , 'SEQUENCE' , 'OTHER' ) union select'COLUMN' , count(*) from sys.col$ union select 'DB LINK' , count(*) from25。按用户查看object种类select u.name schema,&& sum(decode(o.type#, 1, 1, NULL)) indexes,sum(decode(o.type#, 2, 1, NULL)) tables,&& sum(decode(o.type#, 3, 1, NULL))clusters,&& sum(decode(o.type#, 4, 1, NULL)) views,&& sum(decode(o.type#, 5, 1,NULL)) synonyms,&& sum(decode(o.type#, 6, 1, NULL)) sequences,sum(decode(o.type#, 1, NULL, 2, NULL, 3, NULL, 4, NULL, 5, NULL, 6, NULL, 1))others&& from sys.obj$ o, sys.user$ u&& where o.type# &= 1 and&&& u.user# =o.owner# and&& u.name && 'PUBLIC'&& group by u.name&&& order bysys.link$ union select 'CONSTRAINT' , count(*) from sys.con$26。有关connection的相关信息1）查看有哪些用户连接select s.osuser os_user_name,&&& decode(sign(48 - command), 1, to_char(command),'Action Code #' || to_char(command) ) action,&&&& p.program oracle_process,& status session_status,&&& s.terminal terminal,&&& s.program program,& s.username user_name,&&& s.fixed_table_sequence activity_meter,&&& '' query,& 0 memory,&&& 0 max_memory,&&&& 0 cpu_usage,&&& s.sid,&& s.serial# serial_num& from v$session s,&&& v$process p&& where s.paddr=p.addr and&&& s.type = 'USER'order by s.username, s.osuser2）根据v.sid查看对应连接的资源占用等情况select n.name,v.value,n.class,n.statistic#from v$statname n,v$sesstat vwhere v.sid = 71 andv.statistic# = n.statistic#order by n.class, n.statistic#3）根据sid查看对应连接正在运行的sqlselect /*+ PUSH_SUBQ */command_type,sql_text,sharable_mem,persistent_mem,runtime_mem,sorts,version_count,loaded_versions,open_versions,users_opening,executions,users_executing,loads,first_load_time,invalidations,parse_calls,disk_reads,buffer_gets,rows_processed,sysdate start_time,sysdate finish_time,'&' || address sql_address,'N' statusfrom v$sqlareawhere address = (select sql_address from v$session where sid = 71)27．查询表空间使用情况select a.tablespace_name "表空间名称",100-round((nvl(b.bytes_free,0)/a.bytes_alloc)*100,2) "占用率(%)",round(a.bytes_alloc/) "容量(M)",round(nvl(b.bytes_free,0)/) "空闲(M)",round((a.bytes_alloc-nvl(b.bytes_free,0))/) "使用(M)",Largest "最大扩展段(M)",to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') "采样时间"from (select f.tablespace_name,&& sum(f.bytes) bytes_alloc,&& sum(decode(f.autoextensible,'YES',f.maxbytes,'NO',f.bytes)) maxbytesfrom dba_data_files fgroup by tablespace_name) a,(select f.tablespace_name,&&& sum(f.bytes) bytes_freefrom dba_free_space fgroup by tablespace_name) b,(select round(max(ff.length)*16/1024,2) Largest,&& ts.name tablespace_namefrom sys.fet$ ff, sys.file$ tf,sys.ts$ tswhere ts.ts#=ff.ts# and ff.file#=tf.relfile# and ts.ts#=tf.ts#group by ts.name, tf.blocks) cwhere a.tablespace_name = b.tablespace_name and a.tablespace_name = c.tablespace_name28. 查询表空间的碎片程度select tablespace_name,count(tablespace_name) from dba_free_space group by tablespace_namehaving count(tablespace_name)&10;alter tablalter table nacreate or replace view ts_blocks_v asselect tablespace_name,block_id,bytes,blocks,'free space' segment_name from dba_free_spaceunion allselect tablespace_name,block_id,bytes,blocks,segment_name from dba_select * from ts_blocks_v;select tablespace_name,sum(bytes),max(bytes),count(block_id) from dba_free_spacegroup by tablespace_29。查询有哪些数据库实例在运行select inst_name from v$active_30. 查找oracle性能瓶颈sqlselect sql_text,spid,v$session.program,process fromv$sqlarea,v$session,v$processwhere v$sqlarea.address=v$session.sql_addressand v$sqlarea.hash_value=v$session.sql_hash_valueand v$session.paddr=v$process.addrand v$process.spid in (操作系统PID);select sid,event,p1,p1text from v$session_31. 获取oracle前10条最耗资源的sql语句SELECT * FROM & (&& SELECT PARSING_USER_ID&&&&&&&&& EXECUTIONS,&&&&&&&&& SORTS,&&&&&&&&& COMMAND_TYPE,&&&&&&&&& DISK_READS,&&&&&&&&& sql_text&&&&& FROM& v$sqlarea&&&& ORDER BY disk_reads DESC && )& & WHERE ROWNUM&11;FSM3.1-INFO: select SystemTitle from p_title (dbsqlinfo) [ 09:14:07,626]FSM3.1-INFO: select PicFileName from p_sysloginpic
(dbsqlinfo) [ 09:14:07,763]FSM3.1-INFO: select PWDEncrypt from p_pwdset where TID='1'
(dbsqlinfo) [ 09:14:10,419]FSM3.1-INFO: select * from p_agent where
and AgentPWD=?
and IsDelete='no'
(dbsqlinfo) [ 09:14:11,232]FSM3.1-INFO: select * from p_loginset where TID='1'
(dbsqlinfo) [ 09:14:11,360]FSM3.1-INFO: select * from p_dept where DeptID='1'
(dbsqlinfo) [ 09:14:11,436]FSM3.1-INFO: select * from p_agentmenu where
AgentID='yqzg' and
TState='审批通过'
(dbsqlinfo) [ 09:14:11,525]FSM3.1-INFO: select SystemTitle from p_title order by TID asc
(dbsqlinfo) [ 09:14:11,618]FSM3.1-INFO: select * from j_cursystemcode
(dbsqlinfo) [ 09:14:11,721]FSM3.1-RROR: select * from p_agentdefaultsite where AgentID='yqzg' :ORA-00942: 表或视图不存在
(dbsqlinfo) [ 09:14:11,967]FSM3.1-INFO: select NodeID from p_agentnode where
AgentID='yqzg'
TState='审批通过' and NodeType='cms'
(dbsqlinfo) [ 09:14:12,031]FSM3.1-INFO: select ButtonID from p_agentbutton where
AgentID='yqzg'
TState='审批通过' and ButtonType='cms'
(dbsqlinfo) [ 09:14:12,076]FSM3.1-INFO: insert
into p_log(KeyID,TID,LogMode,LogType,LogInfo,DeptID,DeptName,AgentID,AgentName,AgentIP,RecordTime) values ('','yqzg','登录','登录','登录系统，登录人：yqzg','1','市委组织部','yqzg','阳泉组工','0:0:0:0:0:0:0:1',' 09:14:12')
(dbsqlinfo) [ 09:14:12,168]FSM3.1-INFO: select * from p_agentmainpic where AgentID='yqzg'
(dbsqlinfo) [ 09:14:12,414]FSM3.1-INFO: select max(ScreenID) from p_desktopself
AgentID='yqzg'
(dbsqlinfo) [ 09:14:12,694]FSM3.1-INFO: select * from p_desktopself
AgentID='yqzg' and ScreenID='1' and UpperID='0'
DesktopShow='yes'
SortID asc
(dbsqlinfo) [ 09:14:12,873]FSM3.1-INFO: select * from p_desktopself
AgentID='yqzg'
TType='yes'
SortID asc
(dbsqlinfo) [ 09:14:12,931]FSM3.1-INFO: select PageHeight,PageWidth from p_desktopself where AgentID='yqzg'
and MenuID='5005'
(dbsqlinfo) [ 09:14:15,107]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:16,604]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:20,865]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:22,266]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:27,499]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:28,465]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
DEADLINE &=''
DEADLINE &=''
) t)where rowno&='1' and rowno&='20'
(dbsqlinfo) [ 09:14:30,297]FSM3.1-INFO: select count(*)
DEADLINE &=''
DEADLINE &=''
(dbsqlinfo) [ 09:14:30,380]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:41,756]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
DEADLINE &=''
DEADLINE &=''
) t)where rowno&='1' and rowno&='20'
(dbsqlinfo) [ 09:14:44,250]FSM3.1-INFO: select count(*)
DEADLINE &=''
DEADLINE &=''
(dbsqlinfo) [ 09:14:44,332]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:51,572]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:14:52,381]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
j_cadreinfo
) t)where rowno&='1' and rowno&='20'
(dbsqlinfo) [ 09:14:57,318]FSM3.1-INFO: select count(*)
j_cadreinfo
(dbsqlinfo) [ 09:14:57,385]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
j_cadreinfo
) t)where rowno&='1' and rowno&='20'
(dbsqlinfo) [ 09:15:01,936]FSM3.1-INFO: select count(*)
j_cadreinfo
(dbsqlinfo) [ 09:15:01,984]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:15:04,339]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:15:07,526]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
j_cadreinfo
) t)where rowno&='1' and rowno&='20'
(dbsqlinfo) [ 09:15:08,978]FSM3.1-INFO: select count(*)
j_cadreinfo
(dbsqlinfo) [ 09:15:09,017]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:15:10,741]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from
) t)where rowno&='1' and rowno&='18'
(dbsqlinfo) [ 09:15:11,927]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:15:13,824]FSM3.1-INFO: select * from (select t.*,rownum as rowno from (select * from j_cadreinfo where A0101='null' and KeyID not in (select RYID from j_zzsh_nrmry where TID='null') ) t)where rowno&='1' and rowno&='15'
(dbsqlinfo) [ 09:15:14,653]FSM3.1-INFO: select TID,TName from p_pagesize order by TID asc
(dbsqlinfo) [ 09:15:17,000]
阅读(...) 评论()}