Question

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 the Mentioned

This question was posed to me during an online interview.

This key question is from Structured Query Language in section SQL Basics of Oracle

Answer 1

Right answer is (b) SELECT Username, Password FROM Users

The best explanation: 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.