victor ebe

victor ebe

  • NA
  • 68
  • 0

Write Query The row with the highest ID Per day

Mar 18 2015 5:04 PM
You have 3 fields ID Date and Total Your table contains multiple rows for the same day which is valid data however for reporting purpose you need to show only one row per day. The row with the highest ID Per day should be returned the rest should be hidden from users( not returned)

Answers (1)