Orcale database table columns a column of a column to identify values, have a simple query is find out

CodePudding user response:

You mean like this?
Select * from table_A
Where col1=XX
The or col2=XX

CodePudding user response:

WITH
T1 AS (
SELECT 1 A FROM DUAL UNION ALL
SELECT the FROM 2 A DUAL UNION ALL
SELECT the FROM 3 A DUAL UNION ALL
SELECT 4 A FROM DUAL UNION ALL
SELECT 5 A the FROM DUAL)
SELECT
STDDEV (A) the standard deviation,
STDDEV_POP (A) the overall standard deviation,
Cumulative STDDEV_SAMP (A) the sample standard deviation,
MEDIAN (A) the MEDIAN,
VAR_POP variance, (A)
Sample variance VAR_SAMP (A)
The FROM T1;