The MIN() Function return the Min value of a selected column.
The basic syntax is as follows:
SELECT MIN(Column_Name) FROM Table_Name |
Syntax For SQL:
SELECT MIN(Salary) FROM Employee |
Employee | ||||
Emp_id | Name | Surname | Salary | Dept_id |
1 | Rajesh | Khanna | 45000 | 2 |
2 | Sneha | Gupta | 55000 | 4 |
3 | Sandeep | Nehte | 95000 | 1 |
4 | Kirti | Patil | 25000 | 3 |
5 | Nilesh | Jadhav | 45000 | 3 |
6 | Dipesh | Das | 35000 | 5 |
7 | Kailash | Rane | 62000 | 1 |
8 | Kavita | Deshpande | 48000 | 3 |
9 | Sanjay | Datt | 50000 | 3 |
10 | Shruti | Hasan | 78000 | 1 |
After Execute:
MIN(Salary) |
25000 |
No comments:
Post a Comment