Interested to Buy Any Domain ? << Click Here >> for more details...
From an Employee table, how will you display the record
which has a maximum salary?
- 29 Answers
- 39833 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / mayank kumar
<-- it will display max salary only-->
Select max(distinct salary)
from employee;
<-- it will display all information of employee having max salary -->
select * from employees
where salary=(select max(distinct salary) from employees);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain aggregate functions are available there in sql?
what are all different types of collation sensitivity? : Sql dba
Mention what plvcmt and plvrb does in pl/sql?
what are the advantages of sql ? : Sql dba
Why we use joins in sql?
What is the mutating table and constraining table?
What is use of trigger?
what is a tablespace? : Sql dba
What are the sql versions?
Explain what is rdbms?
What is snowflake sql?
How is a process of pl/sql compiled?
What type of database is cloud sql?
What are sql data types?
What is procedure in pl sql?
