how to find max salary from the database
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / thakor ranvir
say for example one table employees
then issue below query .using agreegate function
select max(salary) from emlpoyees;
Is This Answer Correct ? | 16 Yes | 1 No |
Answer / sk wazid hussain
select field_name from table_name order by field_name desc
limit 0,1
Is This Answer Correct ? | 3 Yes | 1 No |
Does mysql scale well?
What is slow query log in mysql?
How can we encrypt and decrypt a data presented in a table using mysql?
Tell us something about heap tables?
How large can a mysql table be?
What is myisam?
What is tee command in mysql?
What is the default port for mysql and how it can change?
What does it mean to be case sensitive?
What is the maximum length of a table name, a database name, or a field name in MySQL?
How to check if a record exists in a mysql database php?
What are the advantages/disadvantages of mysql and php?