Jump to content


Photo

Returning highest numeric value


  • Please log in to reply
1 reply to this topic

#1 lional

lional
  • Members
  • PipPipPip
  • Advanced Member
  • 266 posts

Posted 18 September 2005 - 09:26 AM

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

#2 Rederick

Rederick
  • Members
  • Pip
  • Newbie
  • 6 posts
  • LocationNanaimo, BC Canada

Posted 18 September 2005 - 10:07 PM



[!--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--]




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users