Valid price at given date

Question

got a table with dates and prices.

Date                  Price
2012-01-01            25
2012-01-05            12
2012-01-10            10

Is there some kind of function that lets me find what the current price where at '2012-01-07'? Without me knowing of the other dates.

Pseudoquery: select price where currentprice('2012-01-07')

Thanks!

Answer 1

MySQL:

select price from your_table 
where date <= '2012-01-07'
order by date desc
limit 1

SQL Server:

select top 1 price from your_table 
where date <= '2012-01-07'
order by date desc