Sort 107 Discussions, By:
Please Login in order to post a comment
where LAT_N is the northern latitude and LONG_W is the western longitude
why this sentence didnot make any matter for this query?
I think it's supposed to be a red herring.
It's trying to trick you. Just focus on what the question actually wants you to do.
I thought we should add filter condition like where LAT_N > 0 and LONG_W < 0. Either the problem or test case in anwser should be updated to avoid confuse.
I tried the same. This exercise is very confused.
You will get the correct answer by removing*/ symbols and write just a query Select City, State From Station;
its not working
SELECT CITY, STATE from STATION;
dont forget at put semicolon ; at end of line in your query
PUT COMMA(,) IN TNE MIDDLE OF CITY AND STATE
^^ This. No space between City,State. Just the comma
is there a particular reason why we use , over the AND operator in this situation? I have used it before with no problem but when I did it this time it only returned 0 for all my query data. can you tell me what exactly happened here that would be greatly appreciated.?
SELECT CITY,STATE FROM STATION;
not working i also think it first here bt the compiler dont take it.
me too :(
It working , see if you are using MySQL language tab .
can't i use "and" here in place of ","
why we should not use and operator instead of coma?
Because in the SELECT clause we query the column name and these are always written separated by commas (, ).
Even if there are only two column names to be written we separate them by comma.
Also, AND is a operator used in WHERE clause.
SELECT city, state
Don't know why the */ symbols are there suddenly? Confusing for those of us very new to SQL as if you put your code where it suggests the request doesn't work. Assume it's a comment syntax?
The * means 'select all'.
So if you're saying, and I'm going to write this in psuedocode -
Select (all the fields --> or * )
from (the the station table).
Yes, /* ... */ is a multi-line comment. See w3schools SQL Comments tutorial for more details.
/* ... */