GROUP BY in sqlite note working

Question

I'm using GROUP BY in my sql query.

Query is :

SELECT _id, message_type, message_type_id FROM msgs_list GROUP BY message_type_id

This query is not doing the functionality of GROUP BY. **It is functioning like:

SELECT _id, message_type, message_type_id FROM msgs_list

The same query is working perfectly on windows machine, when i download the Data Base from device to the Windows machine.

Observed result:

expected Result :

Can any body suggest the possible solution.

Thanks,
Sha.

Answer 1

As per my knowledge GROUP BY clause can be used with either "aggregate_function" or Having clause.

The GROUP BY Statement