almost 5 years ago
Hi Reader's, Welcome to FindNerd, today we are going to discuss how to use SQL Max ( ) Function in Sql ?
Basically, SQL Max () Function is used to get the maximum value from the selected field.
Syntax of SQL Max () Function :
select max (column_name) from table_name;
Example : Table name : Empl_Info
Id Employee_name Employee_Age Employee _Salary 1 Deepak 25 150000 2 Manoj 24 220000 3 Uday 20 300000 4 Pradeep 35 125,00000 5 Abhishek 26 820000 6 Ravi 25 300000
Now we want find the Highest salary of employee list.
Then we will use below query
select max ( Employee_Salary ) as Highest_Salary from Empl_Info ;
Output :
Highest_Salary 125,00000
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)