Select 10 student from each department

Databases
1

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.

2

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

3

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.

4

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.