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 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; 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 Link to comment https://forums.phpfreaks.com/topic/82890-solved-max/#findComment-421572 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.