Weather Observation Station 1

Sort by

recency

|

592 Discussions

|

  • + 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; /

  • + 0 comments

    SELECT CITY,STATE FROM STATION;

  • + 0 comments

    select city,state from station; where LAT_N = 'northen latitude' and LONG_W = 'western longitude'

  • + 0 comments

    For MySQL

    SELECT city, state FROM station;
    
  • + 0 comments

    SQL is such a powerful language—once you get the hang of writing queries, it feels amazing to be able to pull out exactly the data you need from a database! exchange betting id