How to determine the closest date to the current date in Oracle SQL?

Question

Oracle

How to display prices that are closest to the current date in SQL?
Columns of a similar kind

For part of this question, the answers were given in the comments
*************************************** ******************************************************* ******************************** I
formulate in more detail It is
required to display prices for each product category that are closest to the current one

Answer 1

SELECT *
FROM tablename
WHERE datecolumn <= CURRENT_DATE
ORDER BY datecolumn DESC 
FETCH FIRST 1 ROWS WITH TIES