SaumilP Crappy description, Author must try and be more clear about using even number as ID Column.
rpikussa Agree
h597679894 Agree!
aamb1 Agree!!!
grieros +1 too
ricardobnunes agree
mariolinguito Agree !!!
natalia_hinca Agree!!!
h2084772909 Agree
_imuv15 select distinct city from station where (id % 2) = 0;
robinbernardo01 hi what does the "= 0 do" ????
Sekatsim It is the qualifier for the WHERE statement. (Id % 2) tells SQL to divide the Id by 2 and return the remainder. Since we're looking for only even values we set this to "= 0", as 2%2=0, 4%2=0, etc. If we were looking for odd-numbered Ids, we'd use "= 1" instead, since there's always a remainder of 1 when dividing odd numbers by 2. Hope this helps!
sebanesrine92 Thank you, that was helpful
vijaybmsmba Nice expaination. Thank you. It was Helpful:)
bajpayee_kuntal it's showing error can i get an alternative to it.
adityakumar19951 WE CAN ALSO WRITE MOD(ID,2)=0, BOTH ARE SAME BUT WE CAN WRITE LIKE THIS ALSO.
manish_pal [deleted]
Vijay_Sai That's not working for me.
BansheeGhoul This is not working (for oracle or DB2 ).. I used below command which worked ...
select distinct city from station where Mod(ID,2)=0;
mmkumr [deleted]
TurboPascal This is working with Oracle.
mpk4811 I TRIED FOR IT..... BUT IAM NOT GETTING IT
[DELETED] [deleted]crownkaiz THAT HELPFUL!
ecrajendra1234 Select distinct CITY from STATION where (ID%2) = 0;
[DELETED] [deleted]sahilaroraa17 not working for even mysql
codingdude will work with MYSQL but not ORACLE
kurisannie Not working for oracle.
okami_house_ceo select distinct(city)from station where MOD( id, 2 ) = 0;
_imuv15 select distinct city from station where (id % 2) = 0;
manish_pal % doesn't work here, better use MOD
aamnah MOD()function works in Oracle while%works in MySQL.rahulpal1321996 You are right Manish
_imuv15 select distinct city from station where (id % 2) = 0;
sanket3969 output throws error stating invalid output
GarrethGolding This works for Oracle:
select distinct city from station where (mod(id, 2) = 0);
hrggb2017 Its perfect thank you!
codingdude Great code works with all SQL languages.
Pick_123 WHY USE DISTINCT ? NOT UNDERSTANDING THE MEANING OF YOUR STATMENT .
kosarajur8 to avoid the duplicates
SUBHASHHJ Perfect!! 'Distinct' eliminates duplicate values as asked in the question.
aniruddha97bhatt Thanks :)
ak975734 could explain me the (id%2)=0;
lucas_marchi It's evaluating if the remaining of the division(id/2) is equal to 0. It's a way to discover if a number is even or odd.
IGORFMCOSTA Agree
aysel_danilova agree!
helena_pereira Agree!
hakertm73 Полностью согласен, блять
ediarto agree
kasan_francis I think he was very clear. Alot of people kind of overlooked the part where they said "no duplicates" (including myself) which would have meant using SELECT DISTINCT
al1turan AGREE.
tyr160 Totally agree!
juliansalas080 Agree
ltbatista30 select distinct city from station where Mod(ID,2)=0;
work for Oracle, but it took me a long time to understand what the author really wanted.
wRish agree!
wRish [deleted]beulahbeasleyq81 agreed,
vindhya_pagadala select distinct(city) from station where mod(id,2)='0';
hwb92516 Correct anwser on MYSQL: SELECT DISTINCT a.CITY as CITY from (SELECT ID, CITY FROM STATION WHERE MOD(ID,2)=0) as a;
sandroacoelho Agree
gustavotrr AGREE
hulyacelikuysal yes i agree , it is not clear
marinskiy Here is Oracle solution from my HackerrankPractice repository:
SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2) = 0;
Feel free to ask if you have any questions :)
Carlosdlr Solution for oracle RDBMS
select distinct(city) from station where MOD(id,2) = 0;
dev_FireWolf SELECT DISTINCT City FROM Station WHERE MOD(Id,2) = 0 ORDER BY City;
avneetk2014 select DISTINCT CITY from STATION WHERE (ID % 2) = 0;
I am not sure why this query is not working in Oracle environment. Though it works fine with MYSQL and MS SQL Server. Any idea?
eaccmk //Below should work in Oracle Env:
select distinct city from station where MOD(ID,2)=0;
sanket3969 it passed ..
ayeshaarshad613 No it not passed it
ImtiyazMasodi Yep! It didn't passed for me too... :|
ewe88 What means (id % 2) = 0 ??
Sorry for stupic question. I'm just learning SQL.
loantran [deleted]
rahul432 % gives the remainder when id is divided by 2.
ksankar_scholar To identify the even id
saurabhsadashiv1 MAY BE % IS LIKE OPERATOR
rose_elena It is always good to write code compatible in different SQL flavors.
select distinct city from station where floor(id/2) = ceil(id/2);
amark720 SOLUTION IN ORACLE
select distinct city from station where (mod(id, 2) = 0);
Hackbond Here's what i used for MySQL and it worked
SELECT DISTINCT CITY FROM STATION where (ID%2) = 0 ORDER BY city ASC;Hackbond - The 'SELECT DISTINCT' takes care of duplicates
- The 'WHERE (ID%2) = 0' makes sure that the id is even
- The 'ORDER BY CITY ASC' takes care of the output being dispplayed in ascending order
deepddj SELECT DISTINCT CITY FROM STATION WHERE (ID%2)=0
millsericc MySQL... Round about solution without using MOD:
#evens: SELECT DISTINCT(CITY) FROM STATION WHERE ROUND(Id/2)=Id/2; #odds: SELECT DISTINCT(CITY) FROM STATION WHERE (ROUND(Id/2))-(Id/2)=.5;
Sort 285 Discussions, By:
Please Login in order to post a comment