Select *from people where city='Boston'. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Select *from people where city='Boston'.

it S not workout but which have ans tell me

26th Jul 2017, 6:40 PM
Ganesh Chittalwar
Ganesh Chittalwar - avatar
5 Answers
+ 2
You should write it properly... It is recommended that you write each command on a new line to avoid getting confused i.e write it as: SELECT* FROM [People] WHERE [City] = 'Boston'
27th Jul 2017, 11:10 AM
Lenox Ndubi
Lenox Ndubi - avatar
0
is there a space missing between * and from
26th Jul 2017, 9:24 PM
sneeze
sneeze - avatar
0
You do need enough whitespace (spaces, new lines, etc) between the keywords for the computer to know what you mean. In this case, you don't have a space between * and from. It's okay to put city='Boston' like that because the = tells it you're doing a WHERE clause condition, but the keyword FROM needs to have whitespace around it. It's good practice to use whitespace even if you technically don't need it for the query to run, that way other programmers know what your code does without spending too much time reading it. You should end up with: SELECT * FROM people WHERE city = 'Boston';
27th Jul 2017, 2:58 AM
Matthew Welke
Matthew Welke - avatar
0
A whitespace is needed between * and the keyword From. For instead: Select * From people Where city = 'Boston';
27th Jul 2017, 6:08 AM
Dan28
Dan28 - avatar
0
You need spaces between words buddy
28th Jul 2017, 2:00 AM
Viko Caceres
Viko Caceres - avatar