Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Course exam question 14 mistake
You need to select all columns from a table. The correct answer, which is A, suggests that you write SELECT ALL FROM [table_name], but actually you should write SELECT * FROM [table_name].
3 answers ( 0 marked as helpful)
Hi Ruslan!
Thanks for reaching out.
First, you are right - ALL is not the correct keyword.
Then, can you please confirm you are referring to Q14 from the SQL's course exam? I encounter a different question in the Course Exam of this course now:
Then, can you please confirm you are referring to Q14 from the SQL's course exam? I encounter a different question in the Course Exam of this course now:
Thank you.
Looking forward to your answer.
Kind regards,
Martin
Kind regards,
Martin
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Hi Martin!
It's SQL for Data Science Interviews course.
Hi Ruslan!
Thanks for reaching out.
Yes, you're right. The correct syntax for selecting all columns is:
SELECT * FROM table_name;
using the asterisk symbol - *.
We will adapt the solutions of the relevant exercise from the course exam.
Hope this helps.
Best,
Martin
Thanks for reaching out.
Yes, you're right. The correct syntax for selecting all columns is:
SELECT * FROM table_name;
using the asterisk symbol - *.
We will adapt the solutions of the relevant exercise from the course exam.
Hope this helps.
Best,
Martin