Posts by Paulo Coelho • 1 point

• 0

  votes

  3

  answers

  33401

  views

  A: Select 1 record of each ID based on the last date

  I’m sorry but the code above is wrong: The right thing would be: SELECT DISTINCT(TQ.[COD_VENDEDOR]), TQ.[VAL_META], TQ.[DAT_ATIVACAO] FROM [dbo].[TB_META] TQ WHERE TQ.DAT_ATIVACAO = (SELECT…

  sql sql-server

  answered 10 years, 2 months ago Paulo Coelho 1