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
- 39795 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 sql in java?
Could you please provide oca (oracle 10g) dumps for my certification ?
what is 'mysqladmin' in mysql? : Sql dba
How do I find duplicates in sql?
Explian rowid, rownum? What are the psoducolumns we have?
Is a table valued function object?
Why we use stored procedure instead of query?
Does pdo prevent sql injection?
Can we use delete in merge statement?
What is cross join sql?
What is meant by temporal data?
What types of commands can be executed in sql*plus?
How does a covering index work?
How do I view stored procedures?
What is triggering circuit?
