Last answered:

28 Jul 2020

Posted on:

16 Jul 2020

0

How to Write SQL Subqueries

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 ( 0 marked as helpful)
Instructor
Posted on:

27 Jul 2020

0
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
Posted on:

28 Jul 2020

0
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

Submit an answer