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 |
What is the difference between mysql and sql?
What is username in mysql?
What is mysql database extension?
What is row level locking in access?
What are the differences between mysql vs sql server?
How to get a list of indexes of an existing table?
Can you rename a database in mysql?
What is check constraint?
What are some good ideas regarding user security in MySQL?
What is the hostname for mysql database?
how can you test for null values in a database? : Mysql dba
What is meant by sharding?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)