how to find max salary from the database

Answers were Sorted based on User's Feedback



how to find max salary from the database..

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

how to find max salary from the database..

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

how to find max salary from the database..

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

Post New Answer

More MySQL Interview Questions

Does mysql scale well?

0 Answers  


What is slow query log in mysql?

0 Answers  


How can we encrypt and decrypt a data presented in a table using mysql?

0 Answers  


Tell us something about heap tables?

0 Answers  


How large can a mysql table be?

0 Answers  






What is myisam?

0 Answers  


What is tee command in mysql?

0 Answers  


What is the default port for mysql and how it can change?

0 Answers  


What does it mean to be case sensitive?

0 Answers  


What is the maximum length of a table name, a database name, or a field name in MySQL?

4 Answers  


How to check if a record exists in a mysql database php?

0 Answers  


What are the advantages/disadvantages of mysql and php?

0 Answers  


Categories