Write Query The row with the highest ID Per day

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.id,Total from report
left outer join
(select * from
(select Date_ as dat,max(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.....