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. Revising the Select Query I
  5. Discussions

Revising the Select Query I

Sort by

recency

|

960 Discussions

|

  • kalyani_nayeni
     + 0 comments

    Select * from City ( selecting all columns here by using * from city table) Where population >100000 and countrycode = 'USA' ; ( using where clause to filter the population column to get the larger value than 100000 and we are keeping the country code as a USA as per request)

  • BeverleyLeggett
     + 0 comments

    The query selects all columns using SELECT *. sikwin

  • DeliaOwens13
     + 0 comments

    Together, these conditions narrow the result set to large cities in the United States while excluding smaller towns and cities from other countries. 11x game

  • pvj_valadares
     + 0 comments
    SELECT 
    *
FROM 
    CITY
WHERE 
    POPULATION > 100000
    AND UPPER(COUNTRYCODE) = 'USA'

  • akhil_challa06
     + 0 comments

    SELECT * FROM CITY WHERE CountryCode = 'USA' AND POPULATION > 100000;