Multiple choice technology databases

What will be the result of the following SQL statement: SELECT LEFT('Have a nice day.', 4)

  1. Have

  2. The statement will produce error.

  3. day.

  4. Missing parameter
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The SQL LEFT function extracts a specified number of characters starting from the left of the string. Passing 4 as the second parameter to 'Have a nice day.' returns the first four characters, which is 'Have'.

Keep practicing — related questions