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