Do you want the unique records, not all records?
You can get the unique records with the DISTINCT clause.
Use the SELECT query together with the DISTINCT clause to get all the unique records from a table.
You may like:
Learning SQL: Master SQL Fundamentals
You can select all records from a table using this query
SELECT * FROM table;
To get the unique records, use this:
SELECT DISTINCT column FROM table;
This will return all unique records for that column.
To get the unique records, you must specify at least one column.
If you have a table students, you can use the select query to get all records:
sqlite> SELECT * FROM students;
To get unique records use:
sqlite> SELECT DISTINCT name FROM students;
Video demonstration of DISTINCT clause