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 !!!
diego_darochafe1 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:)
akshay93pai nice explanation
unlockzubair123 WELL PARANTHESIS ARE NOT NECASSRY THOUGH CODE WORK FINE WITH THEM SELECT CITY FROM STATION WHERE ID%2=0; THIS MEANT THE SAME THING BECAUSE OF OPERATOR PRECEDENCE BUT ITS A GOOD HABIT TO USE PARANTHESIS. I JUST WANTED NEWBIES TO KNOW THE BASIC POINT
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]akshay93pai ya worked well...Thanks
kshashikant118 yeah you are right but it is not take mod(id,2)=0
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.
jananishajan [deleted]jt4life This is the first time I heard of Mod() is it just for Oracle or something?
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;
iyerhariharan64 mod(id,2)=0 will come. i checked in google search. Still the query is not working for the given question.
jayantjayant11 i tried - select distinct CITY from STATION where (ID % 2) = 0; but doesn't work. Tell me why?
parihari_pratik1 try this in oracle- select distinct(CITY) from STATION where MOD(id,2)=0;
yogesh_bavishi you are right, but it works with MySQL only. Oracle gives error with this syntax for "%". thank
h150303105219 why did you write distinct city rather than only city?
parihari_pratik1 Hi, This is bcz in question it is clearly written that "must exclude duplicate in ur ans" .If u write ur query by using "distinct " then duplicate city names will not be in ur answr.
akshay93pai tried this didnt work but worked with MOD(ID,2)=0
k_sharma510 For some reason using % is giving me an error of invalid character. Any idea why?
prafful_namdev18 This is correct query and can also be write as [select distinct city from station where (id % 2) = 0;]
but answer is showing wrong output.
_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
jayantjayant11 The problem statement states that print all data, excluding duplicate value. So the distinct keyword in SQL allows to fecth only distinct data values. So distinct keyword is used.
kalyanapuuma this was not work for me ,help me to solve this
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';
ccoscina In this particular query, you don't need to use DISTINCT to avoid duplicates. For some reason, you do need to use distinct to have it marked as a correct answer. However, in reality, it doesn't make a difference in this query. There are cases in other types of queries when you can end up with duplicates (especially from joins and such) but in this case distinct should not be required.
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
jayantjayant11 Yes, I agree with you. Atleast he must describe how to use even-odd mathematic in SQL? I tried this "select distinct CITY from STATION where (ID % 2) = 0;" but didn't work.
ivyzhang0329 Agree!!! After I tried 5 times, I still don't know what's wrong with the query.... then I found my misunderstanding led by the ambiguous description....
stiefo_o Agree!
nbaikoziev Agree
maamarjoker Agree
bru_santos88 Agree!
charlescampista Agree!
saddamh21196 THANKS
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 :)
smaniraj15 for ORACLE => SELECT DISTINCT(CITY) FROM STATION WHERE MOD(ID,2)=0 ; for MySQL => SELECT DISTINCT(CITY) FROM STATION WHERE (ID%2)=0 ;
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
digvijay59 This will be work for this problem, Thanks -----select distinct city from station where(id%2=0)
mordiana1506 select distinct CITY from STATION where (ID % 2) = 0
vijaycse087 These query works in MySql
select distinct city from station where id%2=0;
gubbalajaya777 It is showing error in select keyword
Sort 339 Discussions, By:
Please Login in order to post a comment