SQLite Forum

how DISTINCT remove the duplicate rows?
Login
Hello,

I am looking for information in the documentation about how the **DISTINCT** keyword removes the duplicate rows, but couldn't find it.

I want to know what the result shold be when I am using this keyword on a BLOB column.

For example,

```
CREATE TABLE tab(c);
INSERT INTO tab values (1), (1.0);
SELECT DISTINCT c FROM tab;
```
The output will be 1. But why it isn't 1.0?

I want to know if it's been defined.