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

Where is the mysql config file?

472


What are slow queries?

484


How does limit work in mysql?

473


What are the limitations of mysql?

510


What are features of mysql?

478






What do you need to connect php to mysql?

530


How to get a list of all tables in a database?

582


What is prepared statement in mysql?

493


What is mysql architecture?

509


What is deterministic in mysql?

512


Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

999


How do I change the max connections in mysql?

470


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

485


How many columns can be used for creating Index?

578


How you can create a trigger in mysql?

551