SQL Server Course for Beginners with 100+ examples - MIN() Function

The video tutorial explains how to use the MIN function in SQL to find the smallest value in a selected column. It demonstrates this with an example using a database named AMIDDB and an employee table. The tutorial shows how to fetch records and apply the MIN function to find the minimum salary. It also covers how to use an alias to name the result column for better readability.

What is the primary purpose of the SQL MIN function?

• To count the number of rows in a table

• To return the smallest value of a selected column

• To calculate the average value of a column

• To find the maximum value in a table

In the example, what is the name of the database used?

• EMPLOYEE_DB

• AMIDDB

• SALARYDB

• EMPDB

Which SQL command is used to fetch all records from the employee table?

• RETRIEVE * FROM employee

• GET ALL FROM employee

• FETCH ALL FROM employee

• SELECT * FROM employee

What is the minimum salary returned in the example?

• 7000

• 6000

• 5000

• 4000

How can you add a column name to the result of a MIN function in SQL?

• By using the keyword 'NAME'

• By using the keyword 'AS' followed by the alias

• By using the keyword 'COLUMN'

• By using the keyword 'LABEL'