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. Select All
  5. Discussions

Select All

Sort by

recency

|

406 Discussions

|

  • sgrverma1919
     + 0 comments

    SELEXT * FROM CITY

  • sindhuvadithe123
     + 0 comments

    ORACLE PL/SQL:

    SET SERVEROUTPUT ON; BEGIN for r in (SELECT * FROM CITY) LOOP DBMS_OUTPUT.PUT_LINE(r.id || ' ' || r.name || ' ' || r.countrycode || ' ' || r.district || ' '|| r.population); END LOOP; END; /

  • anshuldayal5346
     + 0 comments

    SELECT * FROM CITY; this is the answer for above question

  • dhadamomkar979
     + 0 comments

    i was also facing same issue. but this query will give correct output..

    SELECT * FROM CITY Where COUNTRYCODE IN ('USA','NLD');

  • SVVBathini_w
     + 0 comments

    For MySQL PLatform

    SELECT * FROM city;