Re: Embedded SQL "Nearest number" function?

Given:

create table qtemp.myvalues (myvid integer, myvalue integer);
;
insert into qtemp.myvalues values
( 1, 2016 )
,( 2, 1527 )
,( 3, 1874 )
,( 4, 4769 )
,( 5, 1600 )
,( 6, 158 );

This work for me ( i 7.1 TR6). Substitute values for 1580:

SELECT myvid, myvalue, distance,distancerank
FROM (SELECT myvid,
myvalue,
ABS( myvalue - 1580 ) AS distance,
DENSE_RANK() OVER ( ORDER BY abs( myvalue - 1580 ), myvalue DESC
) AS distancerank
FROM qtemp.myvalues
) AS RankedDistance
WHERE distancerank=1;