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.
select * from city where countrycode = "USA" and population > 100000;
Why isn't this code working but it does when USA is written withing single quotes instead of the double quotes?
I thought that more than one characters had to be enclosed within double quotes! How am I wrong.
Pardon me if I sound silly, I am new to SQL.
Revising the Select Query I
You are viewing a single comment's thread. Return to all comments →
select * from city where countrycode = "USA" and population > 100000;
Why isn't this code working but it does when USA is written withing single quotes instead of the double quotes? I thought that more than one characters had to be enclosed within double quotes! How am I wrong. Pardon me if I sound silly, I am new to SQL.