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
- 39000 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / venubabu addagada
SELECT DISTINCT
( e.emp_salary )
FROM
employee e
WHERE
&n = (
SELECT
COUNT(DISTINCT(e1.emp_salary) )
FROM
employee e1
WHERE
e1.emp_salary > e.emp_salary
);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between blob and text? : Sql dba
how to include numeric values in sql statements? : Sql dba
What is the limitation on the block size of pl/sql?
Is there a 64 bit version of ssms?
Define union, minus, union all, intersect ?
Advantages and disadvantages of stored procedure?
What are the syntax and use of the coalesce function?
What is dba in sql? : SQL DBA
What is the use of %rowtype?
What is user in sql?
What are the different types of dbmss?
Why are aggregate functions called so?
What is over () in sql?
Can %notfound return null after a fetch?
Explain exception handling in pl/sql?
