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)