rajmohan Posted August 22, 2007 Share Posted August 22, 2007 how to get second hightest record in table is there posible in mysql 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 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 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'... 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
Archived
This topic is now archived and is closed to further replies.