sql语句

yk156511 · 发表于 2021-12-15 09:48

select sbzt,
   ip,
   sblx,
   sbxml,

   replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') as A

  from SJSB_SSRE
where to_char(cjsj, 'yyyy-mm-dd') >'2021-12-06'
and to_char(cjsj, 'yyyy-mm-dd') <'2021-12-10'
and sblx = '3'
and sbzt = '3'
and ip = '172.21.188.10'  and A>‘’

想把查询出来的A当做一个限制条件。目前我知道A是不能放where后面。就是想达到类似的效果，要怎么做啊。

梓沐 · 发表于 2021-12-15 10:00

SELECT * FROM
(select sbzt,
   ip,
   sblx,
   sbxml,

   replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') as A

  from SJSB_SSRE
where to_char(cjsj, 'yyyy-mm-dd') >'2021-12-06'
and to_char(cjsj, 'yyyy-mm-dd') <'2021-12-10'
and sblx = '3'
and sbzt = '3'
and ip = '172.21.188.10' )  WHERE A>‘’

kulerop · 发表于 2021-12-15 10:00

你这个sql语句怎么写那么多条件，看着眼晕。一般遇到这种情况我都用框架调用。简单明了

梓沐 · 发表于 2021-12-15 10:01

按道理日期直接不用这么麻烦，再转成字符串

ma_dragon · 发表于 2021-12-15 10:06

select sbzt,
   ip,
   sblx,
   sbxml,

   replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') as A

  from SJSB_SSRE
where to_char(cjsj, 'yyyy-mm-dd') >'2021-12-06'
and to_char(cjsj, 'yyyy-mm-dd') <'2021-12-10'
and sblx = '3'
and sbzt = '3'
and ip = '172.21.188.10'
and replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') >‘’

永恒陌 · 发表于 2021-12-15 10:22

不能扔where后边，试试能不能扔having后边

alan3258 · 发表于 2021-12-15 10:35

select * from ( select sbzt,
   ip,
   sblx,
   sbxml,

   replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') as A

  from SJSB_SSRE ) t
where to_char(t.cjsj, 'yyyy-mm-dd') >'2021-12-06'
and to_char(t.cjsj, 'yyyy-mm-dd') <'2021-12-10'
and t.sblx = '3'
and t.sbzt = '3'
and t.ip = '172.21.188.10'  and t.A>''

chengxuyuan01 · 发表于 2021-12-15 11:07

在外面再加一层select，把查出来的结果作为一个表，A作为一个字段，重新select，A字段就可以作为一个条件使用了

Atlantis908 · 发表于 2021-12-15 13:25

select sbzt,
   ip,
   sblx,
   sbxml,

   replace(substr(to_char(xgsj, 'yyyy-mm-dd-hh24-mi-ss'), 12, 8),
            '-',
            '') as A

  from SJSB_SSRE
where to_char(cjsj, 'yyyy-mm-dd') >'2021-12-06'
and to_char(cjsj, 'yyyy-mm-dd') <'2021-12-10'
and sblx = '3'
and sbzt = '3'
and ip = '172.21.188.10'
having A>‘’

素问何问 · 发表于 2021-12-15 13:56

SELECT ... FROM SJSB_SSRE, A WHERE A.??> ...

帐号		自动登录	找回密码
密码			注册[Register]

[求助] sql语句

免费评分

免费评分