miftahul151136 where LAT_N is the northern latitude and LONG_W is the western longitude
why this sentence didnot make any matter for this query?
marinskiy Here is Oracle solution from my HackerrankPractice repository:
SELECT CITY, STATE FROM STATION;
Feel free to ask if you have any questions :)
gpratapsingh901 select city, state from station;
rahulhacker123 select CITY,STATE from STATION;
riteshjha0270 SELECT CITY,STATE FROM STATION;
nkiran19 why there is where condition then.
riteshjha0270 I think you don't know even a single word in english. "where LAT_N is the northern latitude and LONG_W is the western longitude" is indicating what is the meaning of LAT_N and LONG_W.
vorlonhomeworld Uh.....that was rude riteshjah0270. I'm an American and that part of the condition was not clear to me either, since LAT_N and LONG_W are looking for numbers that aren't supplied, there's no way to do the query as requested since we don't know what the fuck to supply for LAT_N and LONG_W. (The WHOLE QUESTION reads as
Query a list of CITY and STATE from the STATION table where LAT_N is the northern latitude and LONG_W is the western longitude.. Also your post came across as a flame, that's not cool!
simplemindedtech There isnt a "where" condition because you are selecting all items in the 2 columns provided.
vijayasrisriniv1 Solution in MYSQL.... select city,state from station;
hp6067 Don't know why the */ symbols are there suddenly? Confusing for those of us very new to SQL as if you put your code where it suggests the request doesn't work. Assume it's a comment syntax?
harrypotter0 select city,state from station;
Toogood2017 Was the 'enter query here' in comment form just a trick? previous problems were just empty. I wrote the code fine all along, it was just in comments! Boo to your trickery... and my beginner outlook. :(
pushkalsharma203 SELECT CITY,STATE FROM STATION ORDER BY STATE DESC;
IS WORKING SIR PLEASE EXPLAIN ME
ginppian The question is only 'Query a list of CITY and STATE from the STATION table.'
simplemindedtech its working because you have selected the proper audience which is "SELECT CITY,STATE FROM STATION" and additionaly adding a clause statement to order your already queried results. Adding some sauce to your code to dress it up isn't a bad thing.
Sort 61 Discussions, By:
Please Login in order to post a comment