你的意思是这样? select * from table_A where col1=XX or col2 =XX
WITH T1 AS ( SELECT 1 A FROM DUAL UNION ALL SELECT 2 A FROM DUAL UNION ALL SELECT 3 A FROM DUAL UNION ALL SELECT 4 A FROM DUAL UNION ALL SELECT 5 A FROM DUAL ) SELECT STDDEV(A) 标准偏离, STDDEV_POP(A) 总体标准偏离, STDDEV_SAMP(A) 累积样本标准偏离, MEDIAN(A) 中位数 , VAR_POP(A) 方差 , VAR_SAMP(A) 样本方差 FROM T1 ;
select * from table_A
where col1=XX
or col2 =XX
T1 AS (
SELECT 1 A FROM DUAL UNION ALL
SELECT 2 A FROM DUAL UNION ALL
SELECT 3 A FROM DUAL UNION ALL
SELECT 4 A FROM DUAL UNION ALL
SELECT 5 A FROM DUAL )
SELECT
STDDEV(A) 标准偏离,
STDDEV_POP(A) 总体标准偏离,
STDDEV_SAMP(A) 累积样本标准偏离,
MEDIAN(A) 中位数 ,
VAR_POP(A) 方差 ,
VAR_SAMP(A) 样本方差
FROM T1 ;