Posts by cvhg • 15 points

• 0

  votes

  1

  answer

  336

  views

  Q: Return last entry of each object in the database

  I have two tables: monitor_carro id serial | setor_id | modelo | ano | placa monitor_evento id serial | lat | long | data | fkfuncionario_id | time | carro The monitor_event table has only one…

  sql query postgresql

  asked 9 years, 4 months ago cvhg 15

• 1

  votes

  3

  answers

  354

  views

  Q: Return the last entry of different Postgresql objects

  Supposing I have two tables: Car containing: plate, year, ect.. Event containing: car, lat, long, date, time, etc.. How could I return only the last entry of each car in the event table?…

  sql postgresql

  asked 9 years, 4 months ago cvhg 15