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.
Revising the Select Query I
Revising the Select Query I
Sort by
recency
|
796 Discussions
|
Please Login in order to post a comment
It sounds like you're having trouble revising a SELECT query or understanding its structure. Here's a basic template for a SELECT query in SQL to help you get started:
sql Copy code SELECT column1, column2, ... FROM table_name WHERE condition;
Create Database American_City; Use American_City; Create table City ( Id int, Name Varchar (17), Countercode Varchar(3), District Varchar(20), Populaion int );
For MySQL
im not an american, the code was given without proper input values. so every values i inputed was base on assumption.
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA'