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

|

375 Discussions

|

  • rylm04
     + 0 comments

    SELECT ID, NAME, COUNTRYCODE, DISTRICT, POPULATION FROM CITY; OR SELECT * FROM CITY; This symbol '*' represents all columns :))

  • veeragonivignes1
     + 0 comments

    SELECT * FROM CITY;

  • AP23110011349
     + 0 comments

    MySQL:

    select* from CITY

    where COUNTRYCODE='USA' or COUNTRYCODE='NLD';

  • chandrautama
     + 1 comment

    The question is weirdly formulated. Why is it not just "Query all entry in the table"?

  • SVVBathini
     + 0 comments

    For MySQL

    SELECT * FROM city;