Azazia Software Knowledgebase
Search:     Advanced search
Browse by category:
Contact Us

Obtaining the maximum value in a numerical list of data in a mysql table

Add comment
Views: 536
Votes: 0
Comments: 0
Posted: 11 Feb, 2009
by: Patridge B.
Updated: 11 Feb, 2009
by: Patridge B.
TABLE_VALUE

id value
1 1
2 5
3 6
4 20
5 7

mysgl> select value from table_values  order by value +0 desc limit 1;"

value
20

mysql>
Others in this Category
document Using an alternate MySQL user account other than the MySQL root user with Data Center Audit (DCA)
document How to Change a mysql userid password if the password is blank ( an empty space or carriage return)
document I have run the installer however it says it will not connect to the database (unable to connect to database).
document How do I manually create the DCA MySQL Database and Tables on Windows?
document How to verify I have the mysql password set prior to installation on a Windows Machine
document mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in



RSS