SQL
Assuming U ...
Site Language: English
Українська
English
Русский
Programming Tests
Login
Sign Up
Programming Tests
Theory
Snippets
Papers
Landing
Android
Prices
FAQ
Cosmo Story
Terms and Conditions
Privacy Policy
Cookies Policy
Send Feedback
Assuming USERS table exists, what will
SELECT 1 FROM USERS
return?
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
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.
SELECT-clause
1
(1)
Like
Login in
to like
Comment
Login in
to comment
Share
Tweet
S
QL
Quiz
Login to learn SQL
or
Read more about
SQL Quizzes
Follow CodeGalaxy
Mobile Beta
Send Feedback
Sign Up Now
or
Subscribe for future quizzes
Login in to like
Login in to comment