468,505 Members | 1,668 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,505 developers. It's quick & easy.

even id numbers in a table called station

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....
Expand|Select|Wrap|Line Numbers
  1. SELECT CITY FROM STATION WHERE MOD(ID,2) = 0;
  2.  
BUT ITS NOT WORKING
Mar 2 '18 #1
1 2413
Frinavale
9,735 Expert Mod 8TB
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)
Mar 5 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Caro | last post: by
6 posts views Thread by devoreband | last post: by
Shinzon
7 posts views Thread by Shinzon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.