This function is used to get the minimum value from the selected field .
Syntax :
select min ( column_name ) from table_name ;
Example :
Table name : Employee_Info
Id Employee_name Employee_Age Employee _Salary
1 Mukesh 23 120000
2 Ayush 24 200000
3 Ishan 20 400000
4 Pranav 35 123,00000
5 Abhishek 26 800000
6 Ravi 25 300000
7 David 40 8000
Query to select minimum salary from a table :
select max ( Employee_Salary ) as Lowest_Salary from Employee_Info ;
Output :
Lowest_Salary
8000
0 Comment(s)