select 10 student from each department

[divinequran]

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.

[SpacePhoenix]

Is the random student to be selected from all the departments or 1 from each department?

[divinequran]

This is not the entire database. I want to select ten students from each department. cosider I have some 20 depatment in my college. I have to select ten student from each department. Hope now you have got it.

[divinequran]

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.

This is not the entire database. I want to select ten students from each department. cosider I have some 20 depatment in my college. I have to select ten student from each department. Hope now you have got it.