Assuming U ...
Terms and Conditions
Assuming USERS table exists, what will
SELECT 1 FROM USERS
It will return "1"
Query will return number of records in USERS table
Query will return first record from USERS table
Query will return "1" as many times as number of records USERS table have
Query will fail because of an error
"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.
Read more about