Interview Question

What is MIN()?

MIN returns the smallest non-null value.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

MIN returns the smallest non-null input value. • It works with orderable data types. • Null inputs are ignored. • With no input rows, the result is NULL.

💡 SQL Example

SELECT MIN(price) FROM products;

Result

9.99

⚡ Quick Revision

MIN returns the smallest non-null value.

←

PreviousWhat is MAX()?

NextWhat are string functions?

→