0 votes
in Oracle by

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

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Nov 25, 2021 in Oracle by DavidAnderson
+1 vote
asked Nov 24, 2021 in Oracle by DavidAnderson
...