How to get Distinct records from SQLITE table in flutter?

Question

I am having a table like this.

I want to write a query in sqlite in flutter to get all the records where id are different. For above table output should be:-

How should I work this out?

Answer 1

Try this query

SELECT * FROM table_name GROUP BY id

Answer 2

Just use the word "distinct on columnName" after the select statement like this:

select distinct on id *
from table

For reference and more clarity check this out.