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
R_A_T_E Thank you! :)
brdamico Agree
sagar_hiren Agree!!
baisestar Agree
elli0t_4lders0n Agree
ahmet229 Agree
kalikaua agree
better_sunjian agree!!!
superstj AGREE
sh_morshedi agree
rdas_879 AGREE
h1254755805 Agree
halfweight Agree
5onic Agree
Joshua_t_hughes Agree
SanskarChoudhary Agree
symbianerfullbr1 agree
tirukumaran Agree
shihao10Civil [deleted]shihao10Civil Agree
Laziest_Coder agree
praveenrao0437 Agree
erwinguntoro9e16 absolutely agree
naveenrathnam99 agree
kunalverma889 agree!!
shubham_v_dupare agree
sholehudinimam agree
aman_tiwari1 agree
marlena_gondek96 agree
colinpan17 agree
oleksandr_boiko1 agree
h786868657 agree
[deleted] AGREE
jkrishnanm009 agree
Ani789yagnik AGREE
WittyJudge Agree
[deleted] Agree
kumar_vinit2189 Agree
mdenus084 AGREE
WittyJudge Agree
arsen_budumyan Agree <3
Snowy_2003 OwO Disagree!
mlane4 NO
Zhipengnator Agree!
natalia_hinca Agree!!!
h2084772909 Agree
kalikaua agreee
rajdivyansh97 AGREE
rdas_879 AGREE
mitchellojeda agree
Snowy_2003 OwO Disagree!
pruthvi_hingu 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
mhaddaqah THANKS MAN !
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
rafroz Well, you need to add "Distinct" otherwise it will fetch the duplicate data.
shubhamjat194 where
dbqmdl01 Thank you for your kindful answer!!!!!!!
thippeswamydcts May I know how does sql identifys its ID properly?, because (id%2)=0 , e.g (2%2)=0 -> 0=0 true, there is no ID here
pravallikapilli1 In the paranthesis enclosed (id%2)=0 here we are performing the arithmetic operation i.e %2 on ID .so in this way sql identifies ID .
sajad_ahmadi_ro1 Agree
prachiagrawal941 thank u so much. it is very helpful. u explained it very nicely and clearly.
piter_ssbrito THANKS, NICE EXPLANATION
bansalanujyadav yeah.. this is very nice explanation thnku
SCOTTOLIVARES22 Great explanation. Thank you.
ozanthony21 [deleted]
bajpayee_kuntal it's showing error can i get an alternative to it.
taogaming Not all DB types use the exact same keyword for modular arithmetic. In Oracle its MOD(ID,2).
codefreak_jr thank you so much
bishmay_24 Thank You So Much!
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]jsuarez45 that was so helpful, thanks friend :)
y16cs896 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
yw_yingwen I try this, it shows error. Do you know what's the issue?
shivayush143 y we use distinct here
iam_psm7 coz we need no duplicates
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.
prasanth_bhadra2 select distinct city from station where mod(id,2)=0; -----> select as oracle
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;
vaibhav31595 yes man it works and thank you so much
ayushchandore33 Yep, this works for me
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.
thoi_sinha Thats helpful. Thanks!
AkshayKReddy It is written in the question but it was not mentioned explicitly that duplicates will be there. I am guessing the data itself has repeated entries of the same city.
nasminjiwani to avoid duplication..
kamblev150 because DISTINCT remove(discard) the duplicate attributes in city column
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?
Graf_Fixer Maybe because you use Oracle. Try "MOD (id, 2) = 0" instead "(id % 2) = 0";
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.
dbqmdl01 [deleted]nupursingh775 its not working in oracle
septienianela Could you explain it to me, why "distinct" required for above statement? Thank you..
morphomenelaus4 select distinct city from station where MOD(id,2) = 0;
03nishchayagarw1 nice explaination yes it reallly works...
jasurC0D IT DOES NOT WORK!
halfweight I tried it and it works fine. Try to add distinct in order to select distinct elements. I also changed oracle to mysql
itikalamadhavi01 thanks!! its working...
yasaswinkumar IF I AM USING IT IS COMING LIKE THIS
select distinct city from station where (id % 2) = 0 * ERROR at line 1: ORA-00911: invalid character
WHAT I HAVE TO DO FOR THAT.
kuldeep_singh_c1 showing error. SELECT DISTINCT CITY FROM STATION WHERE (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.ksanasister Thank you!
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
roopasiddappam41 why using mod 2 nd only 2 nd =0
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
lucbatis 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;
mh_manjunatha25 great its working fine.
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
Schwann can't agree more
alesya_radost Agree
Deepjyoti120281 ohh so i am confuse in this questios
dmgachari_sm YEAH...
mohamedelsayed0 Agree
smissaoui Agree.
jbasali Agree!
carglimarques I agree.
gulsumkaygisiz Agree
xadja35 +++
allanjs88 Agree
AyoubMouraji agree
h1254755805 [deleted]mauriciocoruja Agree!
lisandra_rocha1 Agree
gilberto_chavez Agree
victor_pogor Agree!
rachitanayak YES 👏 I 👏 AGREE👏
ziedzaydoun AGREE
neel_a_131 DISAGREE :D
yasaswinkumar y bro
vishnu18697 Agree!!
david_andersson1 Agree
kejianrong410 Agree
joan_garcia05 Agree!
nimrod_seli SELECT DISTINCT CITY FROM STATION WHERE (ID % 2) = 0;
ZidaneSunesara AGREE
bakhoucheadlan1 agree
saurabh_gadekar1 agree
Zaltron_julian That's not necessary anymore.
Istiakshovon001 AGREE
johnkdunyo okay, after thinking through the problem, you'ld realize that the problem is about querying a list of city names without DUPLICATES. This can be achieved by using the 'DISTINCT' keyword after SELECT before CITY.
SELECT DISTINCT CITY FROM STATION WHERE mod(ID, 2)= 0;
Daniel_Ng_XoR [deleted]Luk1to agree
Viking_Pathak I think the description was clear enough to understand ! What is that you guys found crappy about it, please let me kow ?
My query:
SELECT UNIQUE CITY FROM STATION WHERE MOD(ID, 2) = 0;
aroslav_pressbu1 I agree, deam, thouht I am stupid or something as I can not solve the task...
nicyu Yes totaly agree
nahi_aati_coding agreeeeeeee!!
sujimaya03 AGREE
tosinricardo Agree
will_wright Agree
cnorfolk Agree
sidkoshta26 Agree
azim2429 agree!
marreldorgeles Remember even number e.g: 4 is a even ID number
Akshay_P_singh agree
elie4 Agree!
Harshit_shakya99 AGREE
Achiever_D_Paul Agree!
prateekpatel17 Agree
smaniraj15 for ORACLE => SELECT DISTINCT(CITY) FROM STATION WHERE MOD(ID,2)=0 ; for MySQL => SELECT DISTINCT(CITY) FROM STATION WHERE (ID%2)=0 ;karen19971 I went for the %, did'nt know what was wrong until i googled it.
melodymastache THANK YOU! I was wondering why the % wouldn't work for me on oracle...
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 :)
Shahnaz_Esha what is the use of DISTINCT here?
controangel to avoid duplication
Shahnaz_Esha thank u
ajs16597 WHY WE ARE USING MOD() HERE .
Shahnaz_Esha SQL MOD() function is used to retrieve only unique records depending on the specified column or expression .............that's why i did .
owendai111 Any after mod() we need to set it =0
many thanksShahnaz_Esha you're most welcome😊
anish_1si17cs010 SELECT DISTINCT CITY FROM STATION WHERE MOD(STATION.ID,2)=0;
Duplicate entries can be removed by using DISTINCT and for checking whether the ID is odd or even , we use MOD() in SQL
GhMaster I believe using binary & operation is the best solution here.
A5537 You have a good point, but some people may need an example to understand what you mean by this.
Modulus division by any non-negative power of 2 can be replaced by bitwise AND operator
&with (2 ** n) - 1 as the second operand, so WHERE conditionMOD(ID, 2) = 0may be turned intoID & 1 = 0.
Sort 885 Discussions, By:
Please Login in order to post a comment