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.
  1. Prepare
  2. SQL
  3. Basic Select
  4. Weather Observation Station 1
  5. Discussions

Weather Observation Station 1

Sort by

recency

|

595 Discussions

|

  • hadaganpat42
     + 0 comments

    SELECT CITY,STATE FROM STATION;

  • mohannaidu2004
     + 0 comments

    Select City, State From Station Where LAT_N>0 AND LONG_W>0;

  • baerrenvile3672
     + 0 comments

    Nice problem! I like how it reinforces the basics of SQL SELECT statements while keeping the instructions clear. The tip about avoiding the AS keyword is especially useful since it can trip up beginners. I’m going to try writing the query in a single line as suggested and see if I can get my first star.

  • imadlia129
     + 0 comments
                                          PL/SQL

    BEGIN for rec IN ( select City, State from station ) Loop DBMS_OUTPUT.PUT_LINE ( rec.City || ' ' || rec.State ); END Loop; END; /

  • mraghavi009
     + 0 comments

    SELECT CITY,STATE FROM STATION;