更改您的查询以获得分组结果。

例如选择dept，count *）来自table1 group by dept

Change your query to get group wise results.
For e.g. select dept, count*) from table1 group by dept