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 are the purposes of using enum and set data types?
What are the functions used to encrypt and decrypt the data present in mysql?
What is the full meaning of mysql?
How do I transfer data from one database to another in mysql?
Use a regular expression to find records. Use “REGEXP BINARY” to force case-sensitivity. This finds any record beginning with r.
What is the use of i-am-a-dummy flag in mysql?
Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows
Which statement is used in a select query for partial matching?
How can I create table in mysql?
How do we delete a row in a table?
How do I install mysql?
How can we get the number of rows affected by query?
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)