Posts by Fabio Souza • 21 points

• 1

  votes

  2

  answers

  210

  views

  A: Get older value from another table

  Thank you all for your help. I managed to solve it in the following way: select e.produto, e.saldo from estoque e where CAST(Right('00' + Cast(Year(e.data) as sql_varchar),4) + '-' + Right('0' +…

  sql query

  answered 8 years, 8 months ago Fabio Souza 21

• 1

  votes

  2

  answers

  210

  views

  Q: Get older value from another table

  need to create a query that returns the oldest stock of each product within a specified period: Tabela Produtos: ID DESCRICAO 1 TOMATE 2 ABACAXI Tabela Estoque: DATA HORA PRODUTO ESTOQUE 01/01/2015…

  sql query

  asked 8 years, 8 months ago Fabio Souza 21