get largest number from mysql row

[Reaper0167]

Is there any easy way to get the largest number from a mysql row?

 

I have a column in mysql called count. and each users number could be different.

 

If i want to display 10 results starting at the largest number, what would be the best way?

[premiso]

Using the MAX function.

 

Tutorial here: http://www.tizag.com/mysqlTutorial/mysqlmax.php

[sader]

SELECT * FROM `users_table` ORDER BY `count` DESC LIMIT 0, 10

[perseadrian]

Is there any easy way to get the largest number from a mysql row?

 

I have a column in mysql called count. and each users number could be different.

 

If i want to display 10 results starting at the largest number, what would be the best way?

 

select max(row_you_want) from table where condition; This it's the best way.

[PFMaBiSmAd]

i want to display 10 results starting at the largest number

 

To do what was asked, you would need to use a query like sader posted.

[Reaper0167]

The examle in the link that premiso provided does not make sense. When it shows the table displayed, it is not in order from largest number to smallest number. I will try what sadar said.