Assuming USERS table exists, what will
SELECT 1 FROM USERS
return?
Explanation
"1" is treated as a constant here.
It is returned as a usual value that would be returned for every record in USERS table in a regular query.
Therefore, "1" will be returned ass many times as there records in USERS table.
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback