Given the table Employees with column Salary containing values (3000, 4500, 5000, 4000), what will the query SELECT MIN(Salary) FROM Employees; return?

medium📝 query result Q4 of 15

SQL - Aggregate Functions

Given the table Employees with column Salary containing values (3000, 4500, 5000, 4000), what will the query SELECT MIN(Salary) FROM Employees; return?

A4000

B4500

C5000

D3000

Step-by-Step Solution

Solution:

Step 1: Identify the smallest salary value
The values are 3000, 4500, 5000, and 4000; the smallest is 3000.
Step 2: Understand MIN() returns smallest value
MIN(Salary) returns 3000 as it is the minimum salary.
Final Answer:
3000 -> Option D
Quick Check:
MIN(Salary) = 3000 [OK]

Quick Trick: MIN() returns the smallest number in the list [OK]

Common Mistakes:

MISTAKES

Choosing a random value
Confusing MIN() with MAX()
Not checking all values

Master "Aggregate Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More SQL Quizzes

Given the table Employees with column Salary containing values (3000, 4500, 5000, 4000), what will the query SELECT MIN(Salary) FROM Employees; return?

Step 1: Identify the smallest salary value

Step 2: Understand MIN() returns smallest value

Final Answer:

Quick Check:

Want More Practice?