rajmohan Posted August 22, 2007 Share Posted August 22, 2007 how to get second hightest record in table is there posible in mysql Quote Link to comment https://forums.phpfreaks.com/topic/66105-solved-select-second-top-record-in-table-mysql/ Share on other sites More sharing options...
pranav_kavi Posted August 22, 2007 Share Posted August 22, 2007 u can try dis, select * from table where col1<(select max(col1) from table) order by col1 desc limit 1 Quote Link to comment https://forums.phpfreaks.com/topic/66105-solved-select-second-top-record-in-table-mysql/#findComment-330645 Share on other sites More sharing options...
rajmohan Posted August 22, 2007 Author Share Posted August 22, 2007 great man really nice it is working keep in touch Quote Link to comment https://forums.phpfreaks.com/topic/66105-solved-select-second-top-record-in-table-mysql/#findComment-330650 Share on other sites More sharing options...
pranav_kavi Posted August 22, 2007 Share Posted August 22, 2007 pls make the status of the post to 'SOLVED'... Quote Link to comment https://forums.phpfreaks.com/topic/66105-solved-select-second-top-record-in-table-mysql/#findComment-330653 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.