Interested to Buy Any Domain ? << Click Here >> for more details...
how to find max salary from the database
- 3 Answers
- 5838 Views
- I also Faced
- E-Mail Answers
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 |
How do you concatenate strings in mysql?
How to find second highest salary from a table?
How do I create a mysql username and password?
Can I use mariadb instead of mysql?
What is longblob in mysql?
What is check constraint?
How to use triggers to track changes in mysql?
How to get nth highest salary from table in a mysql?
Which command is used to view the content of the table in mysql?
What does do in mysql?
What is the difference between BLOB AND TEXT?
What is indexing in mysql?
-
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)
