The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

How to Write SQL Subqueries

How to Write SQL Subqueries

0
Votes
2
Answer

Hi after downloading the employee database and loading it onto the MySQL workbench, the code does not run. There is no option to run the entire code.

2 Answers

365 Team
0
Votes

Hi Hui!
Thanks for reaching out.
Please accept my apologies for the delayed response.
Can you please support your question with a screenshot? 
For example, do you mean that the icon for executing the entire code has greyed out? If that’s the case, then you can retry by using the keyboard combination Ctrl + Shift + Enter.
Looking forward to your answer.
Best,
Martin

0
Votes

Hello Hui. Have you tried SELECT statements? SQL subqueries are most frequently used with the Select statement.
For example:

SELECT column_name
FROM table_name  
WHERE column_name expression operator   
( SELECT column_name  from table_name WHERE … ); 

Could you additionally also attach a screenshot? Would be more than glad to take a look at the code

×
LAST CHANCE
Ready to Learn Data Science?
50% OFF