Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361380 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 / gaurav singh 'viccky'
select salary from user=(select max(salary)from user where
salary < (select max(salary)from user))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I find sql profiler?
What are inbuilt functions in sql?
Which join is like an inner join?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What is sql used for?
What is the difference between truncate and drop statements?
- 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?
What are the three forms of normalization?
What are the various levels of constraints?
How to select all records from the table?
What are the types of sql commands?
What will you get by the cursor attribute sql%found?
What is sql partition?
Explain the types of joins in sql?
what are the join types in tsql? : Transact sql
