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
- 39028 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 the insert into statements in sql?
how to convert numeric values to character strings? : Sql dba
How to display Row Number with Records in Oracle SQL Plus?
What is difference between inner join and cross join?
Explain isolation levels. : Transact sql
what is the use of friend function? : Sql dba
Why self join is used in sql?
What is varchar used for?
What is a constraint?
What is t sql in sql server?
What is package in pl sql?
Is sql free?
What is $$ in sql?
What are types of exception?
How can we store rows in PL/SQL using array?
