Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368647 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / naveen r kumar
SELECT Max(salary) FROM TABLE
WHERE salary NOT IN (SELECT Max(salary) FROM TABLE);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why do we need pl sql?
Is sql a programming?
Why use stored procedures?
Explain commit, rollback and savepoint.
What is oracle pl sql developer?
What does count (*) mean?
What is a call statement? Explain with an example.
what is an alias command? : Sql dba
What is self-join and what is the requirement of self-join?
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
What is example of database?
How insert into statements in sql?
How do I copy a table in sql?
What is pl sql block structure?
Enlist some predefined exceptions?
