From an Employee table, how will you display the record
which has a maximum salary?
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 is a database? : Sql dba
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
what is the difference between nested subquery and correlated subquery?
What are tables in sql?
How to get list of all tables from a database?
What is dialect in sql?
Explain polymorphism in pl/sql.
Which sql most popular?
Why stored procedure is faster than query?
How many types of tables are there?
Can we use distinct and group by together?
What are different types of tables in sql?
What plvcmt and plvrb does in pl/sql?
how to use 'mysql' to run sql statements? : Sql dba
What are the two types of exceptions in pl/sql?