We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Loading...
  1. Practice
  2. SQL
  3. Basic Select
  4. Weather Observation Station 1
  5. Discussions

Weather Observation Station 1

Sort 72 Discussions, By:

votes

  • miftahul151136 + 1 comment

    where LAT_N is the northern latitude and LONG_W is the western longitude

    why this sentence didnot make any matter for this query?

    • kev_rocky + 0 comments

      I think it's supposed to be a red herring.

  • jajudeepali + 1 comment

    You will get the correct answer by removing*/ symbols and write just a query Select City, State From Station;

    • eng_shalu + 2 comments

      its not working

      • neerajswami26 + 0 comments

        SELECT CITY, STATE from STATION;

        dont forget at put semicolon ; at end of line in your query

      • salivinit28 + 0 comments

        PUT COMMA(,) IN TNE MIDDLE OF CITY AND STATE

  • hp6067 + 1 comment

    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?

    • kev_rocky + 0 comments

      The * means 'select all'.

      So if you're saying, and I'm going to write this in psuedocode -

      Select (all the fields --> or * ) from (the the station table).

  • Jitender98 + 0 comments

    MySQL code-

    SELECT city, state
FROM station;

  • meet3698 + 0 comments

    MySQL:

    SELECT CITY, STATE FROM STATION;

    ORACLE:

    SELECT CITY, STATE FROM STATION;

    MS SQL Server:

    SELECT CITY, STATE FROM STATION;

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

    SELECT CITY, STATE
  FROM STATION;

    (From my HackerRank repo on GitHub.)

  • mdmerajalam1319 + 0 comments

    MT SQL CODE

    SELECT city, state FROM station;

  • neerajswami26 + 0 comments

    SELECT CITY, STATE from STATION;

    this will work

  • unlockzubair123 + 0 comments

    BLOODY COMMENTS, AND I'VE BEEN THINKING ALL THE TIME THAT WHAT HAPPENED TO MY MEMORY. :) :) :) :) :)

  • brandon_dicicco + 0 comments

    MS SQL SERVER

    SELECT CITY, STATE FROM STATION;
Load more conversations