Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373263 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
what is foreign key? : Sql dba
what are the t string functions available in tsql? : Transact sql
What are sql commands?
Can procedure in package be overloaded?
What is trigger types in sql?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
Advantages and disadvantages of stored procedure?
what is error ora-03113: end-of-file on communication channel?
Are subqueries better than joins?
How do you bind variables in pl sql?
Which join is default?
What are the properties of a transaction?
What is the main difference between sql and pl/sql?
Why is the cursor important?
What is sql partition?
