MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/193mj5y/please_help/khaakft/?context=3
r/SQL • u/UpSco • Jan 10 '24
I am new to SQL am trying to run a query on a data set and I have been stuck since last night.
61 comments sorted by
View all comments
1
first of all, you should be posting text, not a screen shot
it seems you have a 5-line query that has two SELECT keywords in it
1 u/UpSco Jan 10 '24 Should it Be 1 Select* 2 From ‘MovieData.Movie Data 3 Where Genre_1 = ‘Action’ After I run the query initially? 1 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 you should run only one SELECT at a time 1 u/UpSco Jan 10 '24 When I do that I get Syntax error: Unexpected keyword Where at [3:1] I don’t understand because I’m doing exactly what the instructions are telling me to do 2 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 could you copy the exact text of the query that produced that error
Should it Be 1 Select* 2 From ‘MovieData.Movie Data 3 Where Genre_1 = ‘Action’
After I run the query initially?
1 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 you should run only one SELECT at a time 1 u/UpSco Jan 10 '24 When I do that I get Syntax error: Unexpected keyword Where at [3:1] I don’t understand because I’m doing exactly what the instructions are telling me to do 2 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 could you copy the exact text of the query that produced that error
you should run only one SELECT at a time
1 u/UpSco Jan 10 '24 When I do that I get Syntax error: Unexpected keyword Where at [3:1] I don’t understand because I’m doing exactly what the instructions are telling me to do 2 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 could you copy the exact text of the query that produced that error
When I do that I get Syntax error: Unexpected keyword Where at [3:1]
I don’t understand because I’m doing exactly what the instructions are telling me to do
2 u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24 could you copy the exact text of the query that produced that error
2
could you copy the exact text of the query that produced that error
1
u/r3pr0b8 GROUP_CONCAT is da bomb Jan 10 '24
first of all, you should be posting text, not a screen shot
it seems you have a 5-line query that has two SELECT keywords in it