From an Employee table, how will you display the record
which has a maximum salary?
- 29 Answers
- 32223 Views
- Cap Gemini, Exilant, Synechron, I also Faced
- E-Mail Answers
Answer Posted / sharmila
select emp_name,max(salary)
from Employee.
| Is This Answer Correct ? | 55 Yes | 44 No |
Post New Answer View All Answers
What does select top 1 do in sql?
Does pl sql work in mysql?
How to run pl sql program in mysql?
how to show all tables with 'mysql'? : Sql dba
How do you use a while loop in pl sql?
Why do we use sql constraints?
What is the difference between a procedure and a function?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Is mariadb nosql?
What is the use of sql trace?
What is the difference between an inner join and an outer join?
What are sql ddl commands?
What is dml and ddl?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How delete all data from table in sql?
