470,870 Members | 1,057 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,870 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
2 11769
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
A great resource to learn distinct in sql
Feb 25 '22 #3

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.