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
natalia_hinca Agree!!!
h2084772909 Agree
kalikaua agreee
rajdivyansh97 AGREE
rdas_879 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
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
ozanthony21 [deleted]
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]jsuarez45 that was so helpful, thanks friend :)
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;
vaibhav31595 yes man it works and thank you so much
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.
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;
_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
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;
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...
mohamedelsayed1 Agree
smissaoui Agree.
jbasali Agree!
carglimarques I agree.
gulsumkaygisiz Agree
xadja35 +++
allanjs88 Agree
AyoubMouraji agree
h1254755805 [deleted]
smaniraj15 for ORACLE => SELECT DISTINCT(CITY) FROM STATION WHERE MOD(ID,2)=0 ; for MySQL => SELECT DISTINCT(CITY) FROM STATION WHERE (ID%2)=0 ;
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 :)
coder_aky 100% Working Simple and easy :-)
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;
varunakuthota select DISTINCT CITY from STATION where (ID % 2) = 0
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.
Jitender98 MySQL code-
SELECT DISTINCT(city) FROM station WHERE (id % 2) =0;
Carlosdlr Solution for oracle RDBMS
select distinct(city) from station where MOD(id,2) = 0;
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
Sort 490 Discussions, By:
Please Login in order to post a comment