Question

Assuming USERS table exists, what will

SELECT 1 FROM USERS

return?

Cosmo · Accepted Answer

"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.

Cosmo · Accepted Answer

Query will return "1" as many times as number of records USERS table have

Cosmo · Answer

It will return "1"

Cosmo · Answer

Query will return number of records in USERS table

Cosmo · Answer

Query will return first record from USERS table

Cosmo · Answer

Query will fail because of an error

Follow CodeGalaxy

Mobile Beta