The instructions reads that the AS keyword must be inside of single quotes but the lesson also passes with double quotes.
Is there a reason it should be inside of single quotes or are both ways correct?
@jaydacoder,Could you provide the link to the lessonand give us the FULL code you are using...
Sure, here is the link https://www.codecademy.com/en/courses/learn-sql/lessons/multiple-tables/exercises/aliases
@jaydacoderSo your question waswhat is the syntax for a column aliasand as we are using SQLitedo a google search== discussions / opinions ==sqlite column name alias in quotes site:stackoverflow.com
what is the syntax for a column alias
My question was...
The code works, and the lesson passes with BOTH single quotes and ALSO double quotes, so why is the instructions telling us to use single quotes when double quotes also work?
Is there a difference?
@jaydacoder,IMHOYou are using a lesson and the creator has to have some control on the used-syntaxto be able to do a code-checkso it is explicitly stated, you have to use the single-quotes.....
As a answer to your question single-quotes vs double-quotes for column aliasi recommend to read http://stackoverflow.com/questions/1992314/what-is-the-difference-between-single-and-double-quotes-in-sqland keep in mindevery type Database-system has its specific'sRead some == discussions / opinions= found with google searchsql Why does no database fully support ANSI or ISO SQL standards? site:stackoverflow.com
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.