First and Last

[M artin Prohn]

Hi there,

I have a little problem. I have data in my db i want to collect with functions like Max and Min. I also Need First and Last (as in MS Access) which gives me the first and the last Element in the Collection.
The Access Query is

"Select First(data), Last(data), Max(data), Min(data), Date
From Table
Order By Date, Time
Group By Date"

I'm very new in MySQL. Does anybody have a idea what the mysql-query of this is?

Martin Prohn