How to filter records by date using SQL

Question

I am using SQL Server and need to query in a table the most recent price record as the date. Of all the records, I need him to bring me only 1 and with the current date. How do I do this?

Answer 1

The figure shows that there are several lines for the same product.

The solution varies according to the version of SQL Server. Considering getting the latest information from a single product, we can have:

-- código #2
with Produto_ord as (
    SELECT ID_PRODUTOEMPRESA, DT_DATA, VR_PRECO,
           seq= row_number() over (order by DT_DATA desc)
      from tabela
      where ID_PRODUTOEMPRESA = ___
)
SELECT ID_PRODUTOEMPRESA, DT_DATA, VR_PRECO
  from Produto_ord
  where seq = 1;

Answer 2

It’ll be something like this you’re looking for?

SELECT      TOP 1 *
FROM        Tabela
ORDER BY    DT_DATA DESC