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!!!
natalia_hinca Agree!!!
h2084772909 Agree
kalikaua agreee
rajdivyansh97 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
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
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]
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.
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.
dbqmdl01 [deleted]nupursingh_raje1 its not working in oracle
_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;
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
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 ;
dev_FireWolf SELECT DISTINCT City FROM Station WHERE MOD(Id,2) = 0 ORDER BY City;
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
ridhishree The correct answer for this is :- SELECT DISTINCT CITY FROM STATION WHERE MOD(ID,2)=0;
here distinct keyword is used for eliminating duplicate entries and MOD() is a function used to check for remainder. in C we usually write it as ID%2==0.
Hope you find this helpful. Thank you.
_clfm_ MySQL - clean & correct
Let me know if you have any questions!
SELECT DISTINCT CITY FROM STATION WHERE ID % 2 = 0 ORDER BY CITY;
(From my HackerRank repo on GitHub.)
kunaljain_brt SELECT CITY FROM STATION WHERE MOD(ID, 2) = 0
Sort 376 Discussions, By:
Please Login in order to post a comment