CORR(expression1, expression2)

Let us now check corr(exp1,exp2) function with the following query.

Query

sampledb> select corr(age,mark) as correlation from mytable;   

Result

The above query will generate the following result.

correlation 
------------------------------- 
-0.09637388493048485

The query returns the correlation coefficient value between the two columns age and mark.