asmith Posted December 23, 2007 Share Posted December 23, 2007 is there any way i select the first 2 max number from a column ? id number 1 6 2 10 3 2 4 8 hmm anyway i could select 10 and 8 ? thanks Quote Link to comment https://forums.phpfreaks.com/topic/82890-solved-max/ Share on other sites More sharing options...
trq Posted December 23, 2007 Share Posted December 23, 2007 SELECT id, number FROM tbl ORDER BY number DESC LIMIT 2; Quote Link to comment https://forums.phpfreaks.com/topic/82890-solved-max/#findComment-421562 Share on other sites More sharing options...
asmith Posted December 23, 2007 Author Share Posted December 23, 2007 yea , that'll work. got something similar too. thanks Quote Link to comment https://forums.phpfreaks.com/topic/82890-solved-max/#findComment-421572 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.