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

how to find max salary from the database

Question Posted / premanshu

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

Please Help Members By Posting Answers For Below Questions

Write a query to count the number of rows of a table in mysql.

989

How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.

973

Is mysql connect deprecated?

1017

What is mysql aggregate functions? Explain

1157

What port is mysql running on?

979

What are the drivers in MySQL?

1538

What is difference between unix timestamp and mysql timestamp?

1061

How do we delete a row in a table?

1037

What is row locking in mysql?

1018

How can I see mysql database?

950

What does mysqli_fetch_assoc do?

962

explain GROUPBY & HAVING clause with examples.

2327

How do you login to MySql using Unix shell?

1231

Is Mysql query is case sensitive?

1079

How do you kill a long running query in mysql?

959