divinequran Posted June 19, 2011 Share Posted June 19, 2011 I have a big student database, it has only one table. I want to select 10 student each department on a single mysql query. +---------------------------------------------------------+----------------------+ | student | Dept | +---------------------------------------------------------+----------------------+ | gooch | physics | | aaaaa | mathss | | dvssdg | maths | | sfgsfg | chemistry | | gcbcvb | chemistry | | dgsgsfg | arch | I have a big list like this.. I have to select ten student from each department. how shall I achieve it? Also I want to select student in random each time. Link to comment https://forums.phpfreaks.com/topic/239814-select-n-rows-from-each-department/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.