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
- 39138 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
How can we link a sql database to an existing android app?
How to run pl sql program in mysql?
How to use sql*plus built-in timers?
What are the different set operators available in sql?
Define the select into statement.
How do I run sql?
how can we destroy the cookie? : Sql dba
What is use of term?
How can you save or place your msg in a table?
What does dml mean?
What are operators available in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Is postgresql a nosql database?
what does myisamchk do? : Sql dba
What is an alias command?
