Jump to content

Archived

This topic is now archived and is closed to further replies.

lional

Returning highest numeric value

Recommended Posts

I have a mysql table with a integer data type for one of my fields. I would like to only select the highest numeric value from that field, so that I can use it for manipulation in my php code. Is it possible to retrieve just that highest value.

 

Appreciate any assistance

 

Thanls

 

Lional

Share this post


Link to post
Share on other sites

 

 

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']select[/span] MAX(integerfield) from table; [!--sql2--][/div][!--sql3--]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.