Posts by Hugo Leonardo • 21 points

• 2

  votes

  1

  answer

  24

  views

  Q: How to return the last record of each sale

  How to return the last record of each sale considering the max(date)? +---------+--------------------+---------------+ |venda |Data |id | +---------+--------------------+---------------| |0000001…

  sql oracle

  asked 3 years, 10 months ago Hugo Leonardo 21

• -2

  votes

  1

  answer

  31

  views

  Q: SQL - Set Timestamp in Select

  How do I set the min("Timestamp") in a select and then return the last data where it is different from this min("Timestamp")? My Code: SELECT min("TIMESTAMP") AS PrimeiroLog, ID, UF FROM bd.test…

  sql oracle

  asked 4 years, 7 months ago Hugo Leonardo 21