Assuming U ...
Site Language: English
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.
Login to learn SQL
Read more about
Sign Up Now
Subscribe for future quizzes