how to find max salary from the database

Answer Posted / premanshu

if we have any table of employees and their salary
then the statement will be

select MAX(column_name) AS maxsalary
FROM table name

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is default password for mysql?

565


What are enums used for in mysql?

566


What are federated tables?

693


How to use 'mysql' to run sql statements?

611


How to convert character strings to dates?

612






What is mysql used for?

594


How to create a trigger in mysql?

585


What is a procedure example?

571


Who owns mysql database?

669


can you tell the order of sql select statement? : Mysql dba

559


What is the limit of mysql database?

566


how to Return total number of rows.

616


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?

1772


What is mysqli_connect_error ()?

607


Is mysql is a programming language?

610