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
- 39797 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / suma
SELECT emp_name, salary FROM EMPLOYEES E1
WHERE (0) = (SELECT COUNT(DISTINCT(E2.salary))
FROM EMPLOYEES E2
WHERE E1.salary < E2.salary)
| Is This Answer Correct ? | 13 Yes | 16 No |
Post New Answer View All Answers
What is the difference between delete, truncate and drop command?
In pl/sql, what is bulk binding, and when/how would it help performance?
how can we destroy the cookie? : Sql dba
Explain the insert into statements in sql?
What is t sql used for?
How can you load microsoft excel data into oracle? : aql loader
Explain the the update statement in sql?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How do I view stored procedures?
define sql insert statement ? : Sql dba
What steps server process has to take to execute an update statement?
What is dynamic query?
How do you identify a primary key?
What are the types of queries in sql?
How to disable a trigger name update_salary?
