Which of the SQL statements is correct?
A. SELECT Username AND Password FROM Users
B. SELECT Username, Password FROM Users
C. SELECT Username, Password WHERE Username = 'user1'
D. None of these
Answer: Option B
Solution(By Examveda Team)
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.
Join The Discussion