SELECT the 10 largest value from a database field

[pu8y]

Hi all,

Let's say I have a table with a DateTime field, How can i select the 10 of the latest date value from that?
(I want to get 10 latest date)

What i know is using MAX to get the latest date, but how to get several date instead of only one latest date?

Thank you.

[Alsvha]

You should use "group by" to achieve your goal; something similar to this:

SELECT TOP 10 MAX(dateTimeField)
FROM yourTable
GROUP BY dateTimeField
ORDER BY dateTimeField DESC

[PeejAvery]

Maybe I'm confused...But, why not just use LIMIT?

SELECT dateTimeField FROM table ORDER BY dateTimeField DESC LIMIT 0, 10

[Alsvha]

Maybe I'm confused...But, why not just use LIMIT?

SELECT dateTimeField FROM table ORDER BY dateTimeField DESC LIMIT 0, 10

Limit is MySQL specific - but you are right, there is no need to over complicate.

SELECT TOP 10 dateTimeField FROM table ORDER BY dateTimeField DESC

is enough - no need for MAX or GROUP BY or anything
I think I got confused by the mention of MAX and automatically resorted to GROUP .

[PeejAvery]

Limit is MySQL specific

Ahhh, I did not know that.

[pu8y]

thanks, i have done it with TOP. :P