lional Posted September 18, 2005 Share Posted September 18, 2005 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 Quote Link to comment https://forums.phpfreaks.com/topic/2523-returning-highest-numeric-value/ Share on other sites More sharing options...
Rederick Posted September 18, 2005 Share Posted September 18, 2005 [!--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--] Quote Link to comment https://forums.phpfreaks.com/topic/2523-returning-highest-numeric-value/#findComment-8391 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.