Interested to Buy Any Domain ? << Click Here >> for more details...
how to find max salary from the database
- 3 Answers
- 5982 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 |
What are the different tables present in MySQL?
how to know the tables in database having foreign key?
How to get the current date in mysql?
What is the main different between Null and NOT Null. Difference between Primary and Unique Key. How to Check the database from which application is it possibe.
Which storage engines support transactions in MySQL?
How do I start mysql database?
How do I install mysql workbench?
Is oracle better than mysql?
What is int unsigned?
How do I find the database name in mysql?
What is memory table?
What does it mean to be case sensitive?
-
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)
