Posts by Elton C Ramos • 1 point

• 0

  votes

  2

  answers

  3449

  views

  A: Get only last query sql server record

  Can test: SELECT * FROM TABELA A WHERE A.DATA = (SELECT MAX(A1.DATA) FROM TABELA A1 WHERE A1. CHAVE = A.CHAVE... AND A1.DATA <= SYSDATE); Note: If it is Oracle it is SYSDATE. SELECT A.CODIGO,…

  sql sql-server

  answered 6 years, 12 months ago Elton C Ramos 1