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 mysqli_num?
What is mysql installer?
What is mysql in linux?
What is DDL in MySQL?
What is pdo :: fetch_assoc?
How can you make a database as your current database?
How do I change the max connection in mysql?
What do you need to connect php to mysql?
What is mysql database used for?
What is a blob datatype?
What is memory table in mysql?
What is the difference between sql and mysql and oracle?
Oracle (3259)
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)