From an Employee table, how will you display the record
which has a maximum salary?
Answer Posted / pradeep sahoo
Select * from Employee where sal = (select max(sal) frpm
Employee)
| Is This Answer Correct ? | 25 Yes | 1 No |
Post New Answer View All Answers
How to use distinct and count in sql query? Explain
What are the types of index in sql?
What is schema in sql?
Do ddl statements need commit?
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
State few characteristics of pl/sql?
How do I find duplicates in the same column?
Is sqlexception checked or unchecked?
Explain the difference in execution of triggers and stored procedures?
Why is normalization important?
What is the usage of nvl function?
Explain how can you save or place your msg in a table?
Is stored procedure faster than query?
What is cursor status?
what is data manipulation language? : Sql dba