Sort 80 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.
SELECT CITY,STATE FROM STATION;
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
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.
/* ... */
SELECT city, state
Make sure not to type your code between the /* and */ symbols provided in the code box. Enter your code on a new line. (Anything typed between the two symbols is read as a comment and not executed)
SELECT CITY,STATE FROM STATION
select city, state
Try to change the server to MySQL
my mysql code is :
select city,state from station ;