SQLite Forum

Different results in SELECT DISTINCT
Login
The equivalent statements would be:

```
SELECT DISTINCT login FROM student;
SELECT DISTINCT (SELECT login) FROM student;
SELECT DISTINCT (SELECT DISTINCT login) FROM student;
```

In your example you "forgot" to apply DISTINCT to the output rows in the second case, so the output was not DISTINCT (the default is ALL).