hahaha thinking outside the box :D
I looked at it again just now and the row_number is redundant anyway...
row_number
SELECT unnest FROM unnest(ARRAY[100,200,400,800,1600,3200,6400,128000]) ORDER BY abs(900 - unnest) LIMIT 1;
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.
Auth With Twitter
Auth With GitHub
re: Challenge: Get Closest Number in an Array VIEW POST
VIEW PARENT COMMENT VIEW FULL DISCUSSIONhahaha thinking outside the box :D
I looked at it again just now and the
row_numberis redundant anyway...