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
- 37971 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
What are sql ddl commands?
What is an invalid partition table?
What is the file extension for sql database?
Is primary key an index?
What is coalesce in sql?
What is lexical units in pl sql?
How to avoid duplicate records in a query?
Which is better join or inner query?
What is error ora-01000: maximum open cursors exceeded
What are different types of sql commands?
Can we use threading in pl/sql?
What are the different schemas objects that can be created using pl/sql?
Can you selectively load only those records that you need? : aql loader
How we can update the view?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
