almost 5 years ago
Hi Reader's, Welcome to FindNerd, today we are going to discuss how to use SQL Min () Function in Sql.
SQL Min () Function is used for getting the minimum value from the selected field.
Syntax of SQL Min ():
select min (column_name) from table_name;
Example of SQL Min () Function: Firstly create a table Table name : Empl_Info
Id Empl_name Empl_Age Empl_Salary 1 Deepak 23 15000 2 Manoj 24 22000 3 Uday 25 45000 4 Pradeep 35 125,000 5 Shiva 28 850000 6 Ravi 25 300000 7 Sanjay 40 80000
Now we want find the min salry of employee list.
Then we will use below query
SELECT MIN(Empl_Salary) AS Lowest_Salary FROM Empl_Salary
Output : Lowest_Salary 15000
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Sign up using
0 Comment(s)