over 4 years ago
This function is used to get the maximum value from the selected field .
select max ( column_name ) from table_name ;
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 maximum salary from a table :
select max ( Employee_Salary ) as Highest_Salary from Employee_Info ;
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?
© copyright 2017 FindNerd.com. All rights reserved.
Sign up using