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
- 38004 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / sayed
select top(1) * from emp order by salary desc
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
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 pl sql block in dbms?
What is sql used for?
Can a view be mutating? If yes, then how?
What are the benefits of triggers?
Write an sql query to select all records from the table?
What does over partition by mean in sql?
how does a local variable is defined using t-sql? : Transact sql
How to add a column ‘salary’ to a table employee_details?
how to select first 5 records from a table? : Sql dba
What is pl sql variable?
What is clustered index sql?
How can I speed up sql query?
What are the events on which a database trigger can be based?
What is synonyms?
