even id numbers in a table called station

[sri lalitha]

Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer.

This Was My Solutino....

SELECT CITY FROM STATION WHERE MOD(ID,2) = 0;

BUT ITS NOT WORKING

[Frinavale]

The SQL 'distinct' statement is used to return only distinct (different) values. So if you have multiple records with the same CITY value, this will only return records that have different values (see the link for more details)

[Priyankacoder]

distinct in sql

A great resource to learn distinct in sql