Q9
Which of the SQL statements is correct?
A.
SELECT Username AND Password FROM Users
B.
SELECT Username, Password FROM Users
AnswerC.
SELECT Username, Password WHERE Username = 'user1'
D.
None of these
Answer: Option B
Solution
Answer: Option B
Solution:
Correct order of SELECT, FROM and WHERE clause is as follow:
SELECT column_name1, column_name2, ....
FROM table_name
WHERE condition
So, only
SELECT Username, Password FROM Users
follows the above syntax.