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.

This Question Belongs to SQL >> Sql Miscellaneous

Join The Discussion

Related Questions on Sql Miscellaneous