写过最长的一次sql

最新推荐文章于 2022-08-23 11:00:54 发布
最新推荐文章于 2022-08-23 11:00:54 发布
阅读量1.2k 收藏
点赞数
文章标签： date user join table sql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wjx85840948/article/details/5799036
版权

SELECT (NVL(SJTOTAL, 0) - NVL(TOULIAN, 0) - NVL(WANNENG, 0)) * 0.1 +
       (NVL(TOULIAN, 0)) + (NVL(WANNENG, 0) * 0.8) AS KTZ
  FROM (SELECT (SELECT (CASE
                         WHEN SEASON = 0 THEN
                          CASE
                         WHEN EXISTS
                          (SELECT *
                                 FROM USER_TABLES
                                WHERE TABLE_NAME = 'TB_002_2008_IMP_NAV') THEN
                          (SELECT SUM(NVL(FFUNDNAV, 0))
                             FROM TB_002_2008_IMP_NAV
                            WHERE FDATE IN
                                  (SELECT MAX(TT.FDATE) FDATE
                                     FROM (SELECT TO_DATE('2008-12-21',
                                                          'YYYY-MM-DD') + ROWNUM - 1 FDATE
                                             FROM USER_OBJECTS
                                            WHERE ROWNUM <= 11) TT
                                    WHERE TT.FDATE NOT IN
                                          (SELECT FDATE
                                             FROM TB_BASE_CHILDHOLIDAY
                                            WHERE FHOLIDAYSCODE = 'CH'
                                              AND FCHECKSTATE = 1
                                              AND FDATE BETWEEN
                                                  TO_DATE('2008-12-21',
                                                          'YYYY-MM-DD') AND
                                                  TO_DATE('2008-12-31',
                                                          'YYYY-MM-DD')))
                              AND FSETID IN ('3','4','5'))
                         ELSE
                          0
                       END ELSE(CASE
                                  WHEN SEASON = 1 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM TB_002_2009_IMP_NAV
                                     WHERE FDATE IN
                                           (SELECT MAX(TT.FDATE) FDATE
                                              FROM (SELECT TO_DATE('2009-03-21',
                                                                   'YYYY-MM-DD') + ROWNUM - 1 FDATE
                                                      FROM USER_OBJECTS
                                                     WHERE ROWNUM <= 11) TT
                                             WHERE TT.FDATE NOT IN
                                                   (SELECT FDATE
                                                      FROM TB_BASE_CHILDHOLIDAY
                                                     WHERE FHOLIDAYSCODE = 'CH'
                                                       AND FCHECKSTATE = 1
                                                       AND FDATE BETWEEN
                                                           TO_DATE('2009-03-21',
                                                                   'YYYY-MM-DD') AND
                                                           TO_DATE('2009-03-31',
                                                                   'YYYY-MM-DD')))
                                       AND FSETID IN ('3','4','5'))
                                  WHEN SEASON = 2 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM TB_002_2009_IMP_NAV
                                     WHERE FDATE IN
                                           (SELECT MAX(TT.FDATE) FDATE
                                              FROM (SELECT TO_DATE('2009-06-20',
                                                                   'YYYY-MM-DD') + ROWNUM - 1 FDATE
                                                      FROM USER_OBJECTS
                                                     WHERE ROWNUM <= 11) TT
                                             WHERE TT.FDATE NOT IN
                                                   (SELECT FDATE
                                                      FROM TB_BASE_CHILDHOLIDAY
                                                     WHERE FHOLIDAYSCODE = 'CH'
                                                       AND FCHECKSTATE = 1
                                                       AND FDATE BETWEEN
                                                           TO_DATE('2009-06-20',
                                                                   'YYYY-MM-DD') AND
                                                           TO_DATE('2009-06-30',
                                                                   'YYYY-MM-DD')))
                                       AND FSETID IN ('3','4','5'))
                                  ELSE
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM TB_002_2009_IMP_NAV
                                     WHERE FDATE IN
                                           (SELECT MAX(TT.FDATE) FDATE
                                              FROM (SELECT TO_DATE('2009-09-20',
                                                                   'YYYY-MM-DD') + ROWNUM - 1 FDATE
                                                      FROM USER_OBJECTS
                                                     WHERE ROWNUM <= 11) TT
                                             WHERE TT.FDATE NOT IN
                                                   (SELECT FDATE
                                                      FROM TB_BASE_CHILDHOLIDAY
                                                     WHERE FHOLIDAYSCODE = 'CH'
                                                       AND FCHECKSTATE = 1
                                                       AND FDATE BETWEEN
                                                           TO_DATE('2009-09-20',
                                                                   'YYYY-MM-DD') AND
                                                           TO_DATE('2009-09-30',
                                                                   'YYYY-MM-DD')))
                                       AND FSETID IN ('3','4','5'))
                                END) END) SJTOTAL
                  FROM (SELECT ((CASE
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 0 THEN
                                  1
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 0 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 3 THEN
                                  2
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 3 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 6 THEN
                                  3
                                 ELSE
                                  4
                               END) - 1) AS SEASON
                          FROM DUAL)) AS SJTOTAL,
               (SELECT (CASE
                         WHEN SEASON = 0 THEN
                          CASE
                         WHEN EXISTS
                          (SELECT *
                                 FROM USER_TABLES
                                WHERE TABLE_NAME = 'TB_002_2008_IMP_NAV') THEN
                          (SELECT SUM(NVL(FFUNDNAV, 0))
                             FROM (SELECT FSETID, FFUNDNAV
                                     FROM TB_002_2008_IMP_NAV
                                    WHERE FDATE IN
                                          (SELECT MAX(TT.FDATE) FDATE
                                             FROM (SELECT TO_DATE('2008-12-21',
                                                                  'YYYY-MM-DD') +
                                                          ROWNUM - 1 FDATE
                                                     FROM USER_OBJECTS
                                                    WHERE ROWNUM <= 11) TT
                                            WHERE TT.FDATE NOT IN
                                                  (SELECT FDATE
                                                     FROM TB_BASE_CHILDHOLIDAY
                                                    WHERE FHOLIDAYSCODE = 'CH'
                                                      AND FCHECKSTATE = 1
                                                      AND FDATE BETWEEN
                                                          TO_DATE('2008-12-21',
                                                                  'YYYY-MM-DD') AND
                                                          TO_DATE('2008-12-31',
                                                                  'YYYY-MM-DD')))
                                      AND FSETID IN ('3','4','5')) A
                            INNER JOIN (SELECT FPORTCODE
                                         FROM TB_002_PARA_PORTFOLIO
                                        WHERE FPORTCODE IN ('3','4','5')
                                          AND FPORTATTRIBUTE = '1') B ON A.FSETID =
                                                                         B.FPORTCODE)
                         ELSE
                          0
                       END ELSE(CASE
                                  WHEN SEASON = 1 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-03-21',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-03-21',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-03-31',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '1') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                  WHEN SEASON = 2 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-06-20',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-06-20',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-06-30',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '1') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                  ELSE
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-09-20',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-09-20',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-09-30',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '1') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                END) END) TOULIAN
                  FROM (SELECT ((CASE
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 0 THEN
                                  1
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 0 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 3 THEN
                                  2
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 3 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 6 THEN
                                  3
                                 ELSE
                                  4
                               END) - 1) AS SEASON
                          FROM DUAL)) AS TOULIAN,
               (SELECT (CASE
                         WHEN SEASON = 0 THEN
                          CASE
                         WHEN EXISTS
                          (SELECT *
                                 FROM USER_TABLES
                                WHERE TABLE_NAME = 'TB_002_2008_IMP_NAV') THEN
                          (SELECT SUM(NVL(FFUNDNAV, 0))
                             FROM (SELECT FSETID, FFUNDNAV
                                     FROM TB_002_2008_IMP_NAV
                                    WHERE FDATE IN
                                          (SELECT MAX(TT.FDATE) FDATE
                                             FROM (SELECT TO_DATE('2008-12-21',
                                                                  'YYYY-MM-DD') +
                                                          ROWNUM - 1 FDATE
                                                     FROM USER_OBJECTS
                                                    WHERE ROWNUM <= 11) TT
                                            WHERE TT.FDATE NOT IN
                                                  (SELECT FDATE
                                                     FROM TB_BASE_CHILDHOLIDAY
                                                    WHERE FHOLIDAYSCODE = 'CH'
                                                      AND FCHECKSTATE = 1
                                                      AND FDATE BETWEEN
                                                          TO_DATE('2008-12-21',
                                                                  'YYYY-MM-DD') AND
                                                          TO_DATE('2008-12-31',
                                                                  'YYYY-MM-DD')))
                                      AND FSETID IN ('3','4','5')) A
                            INNER JOIN (SELECT FPORTCODE
                                         FROM TB_002_PARA_PORTFOLIO
                                        WHERE FPORTCODE IN ('3','4','5')
                                          AND FPORTATTRIBUTE = '2') B ON A.FSETID =
                                                                         B.FPORTCODE)
                         ELSE
                          0
                       END ELSE(CASE
                                  WHEN SEASON = 1 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-03-21',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-03-21',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-03-31',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '2') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                  WHEN SEASON = 2 THEN
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-06-20',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-06-20',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-06-30',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '2') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                  ELSE
                                   (SELECT SUM(NVL(FFUNDNAV, 0))
                                      FROM (SELECT FSETID, FFUNDNAV
                                              FROM TB_002_2009_IMP_NAV
                                             WHERE FDATE IN
                                                   (SELECT MAX(TT.FDATE) FDATE
                                                      FROM (SELECT TO_DATE('2009-09-20',
                                                                           'YYYY-MM-DD') +
                                                                   ROWNUM - 1 FDATE
                                                              FROM USER_OBJECTS
                                                             WHERE ROWNUM <= 11) TT
                                                     WHERE TT.FDATE NOT IN
                                                           (SELECT FDATE
                                                              FROM TB_BASE_CHILDHOLIDAY
                                                             WHERE FHOLIDAYSCODE = 'CH'
                                                               AND FCHECKSTATE = 1
                                                               AND FDATE BETWEEN
                                                                   TO_DATE('2009-09-20',
                                                                           'YYYY-MM-DD') AND
                                                                   TO_DATE('2009-09-30',
                                                                           'YYYY-MM-DD')))
                                               AND FSETID IN ('3','4','5')) A
                                     INNER JOIN (SELECT FPORTCODE
                                                  FROM TB_002_PARA_PORTFOLIO
                                                 WHERE FPORTCODE IN ('3','4','5')
                                                   AND FPORTATTRIBUTE = '2') B ON A.FSETID =
                                                                                  B.FPORTCODE)
                                END) END) WANNENG
                  FROM (SELECT ((CASE
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 0 THEN
                                  1
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 0 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 3 THEN
                                  2
                                 WHEN TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 > 3 AND
                                      TO_NUMBER(TO_CHAR(TO_DATE('2009-08-20',
                                                                'YYYY-MM-DD'),
                                                        'MM')) - 3 <= 6 THEN
                                  3
                                 ELSE
                                  4
                               END) - 1) AS SEASON
                          FROM DUAL)) AS WANNENG
          FROM DUAL)
         
         
         
         
          --------------------------------------------------------
         
select * from Tb_002_Para_Portfolio where fportcode in ('3','4','5')
select * from TB_002_2009_IMP_NAV where fdate = TO_DATE('2009-06-30', 'YYYY-MM-DD') and fsetid in ('3','4','5')
update  Tb_002_Para_Portfolio set FPORTATTRIBUTE='1' where fportcode in ('4')
update  Tb_002_Para_Portfolio set FPORTATTRIBUTE='2' where fportcode in ('5')
select * from TB_BASE_CHILDHOLIDAY order by fdate desc

喜哥2022
关注
基于AI大模型实现自然语言转SQL、SQL解释、SQL优化和SQL转换
程序员光剑
06-21 1万+
自定义AI可以是用户自己部署的任意AI模型，例如ChatGLM、ChatGPT、文心一言、通义千问等等，但是自定义的接口输入和输出需要符合自定义的协议规范才可快速使用，否则可能需要二次开发。代码中提供了两个DEMO，只需要配置自定义AI接口地址，以及接口是否流式输出即可查看。具体使用中可以参考DEMO接口来编写自定义接口，或者直接在DEMO接口中进行二次开发，封装自己的自定义接口自定义的流式输出接口配置DEMO自定义的非流式输出接口配置DEMO。
记一次系统被sql注入搞挂的惨痛经历
lisu061714112的专栏
04-22 2797
前言 最近我在整理安全漏洞相关问题，准备在公司做一次分享。恰好，这段时间团队发现了一个sql注入漏洞：在一个公共的分页功能中，排序字段作为入参，前端页面可以自定义。在分页sql的mybatis mapper.xml中，order by字段后面使用$符号动态接收计算后的排序参数，这样可以实现动态排序的功能。 但是，如果入参传入： id; select 1 -- 最终执行的sql会变成： select * from user order by id; select 1 -- limit 1,20 –会把后面
有史以来写过最长的sql
qq764136933的专栏
10-16 954
SELECT -- 单据类型 biz_so_out.biz_type, -- 单据日期 biz_so_out.biz_date, -- 单据号 biz_so_out.bill_no, -- 零售单据号 biz_so.bill_no as biz_so_bill_no, -- 品牌 biz_so_detail_01.brand_uuid, -- 商品名称 biz_so_de...
记录一下，写的最长的sql
qingfeng2556的博客
04-16 1603
 SELECT  * from (        SELECT        tp.id,        tp.status,        tp.number,        tu.user_id,        tu.login_name,        tub.real_name,        tu.phone,        tp.resale_price_ask,        tp....
我到目前为止写的最长的一个SQL语句
勤奋的asialee的博客
03-31 223
[size=large]这个是我昨天写的一个SQL语句，是mysql的，本身想用程序来写的，最后还是用sql写出来了，小有自豪感。但不知道效率如何，还的请高人指点。[/size] [code="sql"] select na.source_node_id as project_id, p.pname, (select pc.cname ...
我迄今为止写的最长的SQL
u010815305的专栏
05-03 718
   今天看我14年实习的时候，当时我的导师在博客中写到了一段差不多50多行的sql，说是他写的最长的sql， 想想工作的这一年，其实我也写了不少sql，因为自身是做数据开发方面的工作，写sql是免不了的，哈哈~ 今天刚好是五一假后上班的第一天，也不想干什么事，就写写博客吧，好久没有记录啦。好，言归正传， 就说sql吧， 去年我们数据组要把之前的从mysql中的提取基础数据的工作给...
写的史上最长的sql语句
kccacmilan的专栏
01-05 3137
select c.nums as sums ,d.direction,e.intersection_name from  (select sum(t.numbers) as nums, b.segmentid,b.intersectionid  from DIM_TRAFFIC_OFFEND_DETECTOR b, (select a.cid, count(cid) as numbers fr
mybatis一个方法执行多条sql_MyBatis一次执行多条SQL语句的操作
weixin_42365141的博客
12-24 2197
有个常见的场景：删除用户的时候需要先删除用户的外键关联数据，否则会触发规则报错。解决办法不外乎有三个：1、多条sql分批执行；2、存储过程或函数调用；3、sql批量执行。今天我要说的是MyBatis中如何一次执行多条语句(使用mysql数据库)。1、修改数据库连接参数加上allowMultiQueries=true，如：hikariConfig.security.jdbcUrl=jdbc:mysq...
*sql注入实战--记一次绕过WTS-WAF拦截注入**
Q963260583的博客
06-04 8969
记一次绕过WTS-WAF拦截注入 关键字搜索 inurl:asp.id= 搜出了一个Asp+Access的小网站，接着尝试进行注入。 但是碰到了拦截，尝试用注释污染参数进行绕过，结果还是不行。 如图所示： 接着尝试改用+号替代空格，居然成功了。 如图： 接着就是尝试用order by 函数匹配了，而且order by 函数也不拦截，得出结果为13. 然后就是进行数据查询了，同时进行表名的猜...
access 一次执行多条sql语句
04-12
### Access一次执行多条SQL语句 在Access数据库管理中，有时我们需要在同一事务中执行多条SQL语句来确保数据的一致性和完整性。例如，在更新某个记录后可能还需要执行其他操作，如增加日志记录等。本文将详细介绍...
见过史上最长的SQL语句（惊）
lexiyao的专栏
05-05 4122
这是同事写的一个进销存的SQL语句，一条语句这么长，大吓人了（数据少的话速度还很快，佩服）。  SELECT Id, GName, Model1, Model2, unit, AverageCost, (Select sum(ActualQty) from StockBill inner join StockBillItems on StockBill.Id=StockBillItem
迄今为止，我写过的最长的SQL语句
Zzz's Blog
12-29 1545
SELECT   wap_user.u_name, NVL (f_pv, 0), NVL (m_pv, 0), NVL (f_se, 0),          NVL (m_se, 0)     FROM (SELECT *             FROM (SELECT   user_id AS fuser1, COUNT (1) AS f_pv
纪念一下写过的最长SQL
ChenX9821的博客
07-27 120
SQL撰写
那些年我写过的最长sql语句
zhengun的专栏
04-19 360
前言    那些年我写过的最长sql语句，在此写成博客，以此备份，便于后续工作参考 目录       1.开通用户数       2.开通用户数明细       3.注册用户数       4.注册用户数明细       5.相似博客推荐    1.开通用户数 SELECT W.REGION_NAME AREANAME, A.PROVINCE_NO areaN...
sqlserver-sql 个人写过最长sql记录 192行
weixin_45774059的博客
08-23 387
sqlserver
个人目前最长sql语句（美化之后）
m0_37997811的博客
04-15 1633
SELECT a.id AS id, a.departmentId AS departmentId, a.rank AS rank, ( SELECT SUM(d.studyTime) FROM tbl_User_Learn_Record AS d WHERE d.userId = a.userId AND d.startTime >= : startTime AND d.startTime...
全世界最长的统计SQL语句，可拆分使用
暴风城基地
06-09 432
全世界最长的统计SQL语句，可拆分使用
长sql写法总结
leadder的博客
06-27 1518
如果各位供职于操纵数据库较多的公司，那么一定避免不了写长sql，会写长sql是程序员的一项默认技能，最近我在研究长sql的写法，首先一条sql根据需求的不同，首先要分析，需求的内容，一般写长sql，都是从最里面开始写，要牢记，sql的作用就是搂数据，怎么能搂出来，就怎么用，sql语句的固定格式永远都是《select + 你想要搂出来的数据 + from + 表名 + where + 限制条件》，...
写一个SQL 预测下一次出现3的概率
最新发布
09-04
我们可以使用SQL语句来计算下一次出现3的概率。首先，我们需要统计数据表中“value”列为3的次数以及总行数，可以使用下面的SQL语句： SELECT COUNT(CASE WHEN value = 3 THEN 1 END) AS count_3, COUNT(*) AS total...
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值