Which Of The SQL Statement 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

Which Of The SQL Statement Is Correct

Ans. Option B) SELECT Username, Password FROM Users is the Correct Answer

In SQL, when you want to retrieve specific columns from a table, you use the “SELECT” statement followed by the column names you want, separated by commas. In this case, “Username” and “Password” are the two columns you want to select from the “Users” table. So, option B is correct.