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
- 37979 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 are the various levels of constraints?
Explain the components of sql?
What is the difference between cross join and natural join?
What does select top 1 do in sql?
What are its different types of dbms?
What is sql and also describe types of sql statements?
What are the advantages of indexing?
What is difference between stored procedures and application procedures?
Does inner join return duplicate rows?
What is pl sql record in oracle?
What is a left inner join?
How do you update f as m and m as f from the below table testtable?
What is data control language (dcl)?
What is the example of procedure?
What is rowtype?
