Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368441 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 / sumit sharma
select sal from (select distinct(sal) from emp where sal is
NOT NULL order by sal dsc) where rownum = 2
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
how to enter numeric values as hex numbers? : Sql dba
What is mutating trigger?
Why is the cursor important?
What is clustered index sql?
How to add a column ‘salary’ to a table employee_details?
Explain the insert into statements in sql?
How do I truncate a word?
What is the primary use of normalization?
Which table is left in join?
What is the difference between Union and Union all. Which is faster.
Explain commit, rollback and savepoint.
Explain autonomous transaction.
Why do we use procedures in pl sql?
What is varchar data type in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
