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
- 38012 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / pree
Select name,salary from Employee where salary in(select max
(salary)
from Employee );
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can a select statement fire a trigger?
how to install mysql? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is rank () in sql?
What is pl sql block structure?
What is constant in pl sql?
Can we create index on primary key?
Explain the uses of a database trigger?
What is primary key in db?
What is the trigger in sql?
What is sqlca in db2?
How is data stored on a disk?
What is query syntax?
What is a subquery in sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
