DEV Community

AntDB
AntDB

Posted on

AntDB-Oracle Compatibility Developer’s Manual P3–57

REGR_INTERCEPT

Calculate the intercept distance.

Example:

select count(*),regr_intercept(t.num,test.num) from 
(select id-1 as id, num from test) as t,test where t.id=test.id ;
 COUNT(*) | REGR_INTERCEPT(T.NUM,TEST.NUM)  
----------+---------------------------------
       28 |               655.2852157477586
(1 row)
Enter fullscreen mode Exit fullscreen mode
REGR_COUNT

regr_count(y, x) counts the number of records for which neither x nor y is empty.

Example:

create table test(id int, num int);
insert into test values(1, 298),(2, null),(3, null),(null, 328),(null, 108),(6, 667);
select regr_count(id, num) from test;

REGR_COUNT(ID, NUM)  
----------------------
                    2
(1 row)
Enter fullscreen mode Exit fullscreen mode

Top comments (0)