EchoFool Posted February 3, 2008 Share Posted February 3, 2008 Hey guys, How do you in mysql find a the "highest value" in a field ? Im trying to find who has the highest number out of all the numbers in the rows in the field "ticket number". Is there a set function to do that? Quote Link to comment https://forums.phpfreaks.com/topic/89211-solved-find-highest/ Share on other sites More sharing options...
pocobueno1388 Posted February 3, 2008 Share Posted February 3, 2008 SELECT MAX(ticket_number) as num FROM table Quote Link to comment https://forums.phpfreaks.com/topic/89211-solved-find-highest/#findComment-456811 Share on other sites More sharing options...
EchoFool Posted February 3, 2008 Author Share Posted February 3, 2008 Thankyou Again! Quote Link to comment https://forums.phpfreaks.com/topic/89211-solved-find-highest/#findComment-456813 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.