Multiple choice technology databases

Which SQL keyword is used to retrieve a minimum value?

  1. DOWN

  2. LOW

  3. MIN

  4. LOWER

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

MIN is an aggregate function that returns the smallest value in a column. DOWN and LOW are not SQL keywords for finding minimum values. LOWER is a string function that converts text to lowercase, unrelated to finding minimum numerical values.