re: Challenge: Get Closest Number in an Array VIEW POST

TOP OF THREAD FULL DISCUSSION
re: Window functions! SELECT unnest FROM unnest(ARRAY[100,200,400,800,1600,3200,6400,128000]) ORDER BY row_number() OVER (ORDER BY abs(900 - unnest)...
 
rhymes profile image rhymes twitter logo github logo
Permalink Report Abuse

hahaha thinking outside the box :D

REPLY
 
dmfay profile image Dian Fay github logo
Permalink Report Abuse

I looked at it again just now and the row_number is redundant anyway...

SELECT unnest
FROM unnest(ARRAY[100,200,400,800,1600,3200,6400,128000])
ORDER BY abs(900 - unnest)
LIMIT 1;
REPLY
code of conduct - report abuse