Write Query The row with the highest ID Per day

Question

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)

Pankaj Kumar Choudhary · Answer

Hello @Victor according your Query. I create a table which look like this. Id Date_ Total 2 2015-03-19 12000 3 2015-03-19 15000 4 2015-03-19 2000 9 2015-03-19 15000 12 2015-03-20 19000 8 2015-03-20 22000 7 2015-03-20 9000 6 2015-03-20 11000 5 2015-03-21 10000 11 2015-03-21 16000 12 2015-03-21 17000 6 2015-03-21 12000 9 2015-03-22 17000 10 2015-03-22 25000 11 2015-03-22 26000 NULL NULL NULL and write the query. select Date_Report.idTotal from report left outer join (select * from (select Date_ as datmax(id) as id from Report group by(Date_))Temp)Red on Report.id=Red.id where report.Date_=Red.dat order by(Report.Date_) and output is: Date Id Total 2015-03-19 9 15000 2015-03-20 12 19000 2015-03-21 12 17000 2015-03-22 11 26000 If above is not according as you wish Then Please Explain what type of the output you want with an Example then i can understand your query very well.....