Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 372950 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 / shanmugasundaram
select min(salary) from tblempsal where salary in(select
distinct
top 2 salary from
tblempsal order by salary desc)
| Is This Answer Correct ? | 20 Yes | 13 No |
Post New Answer View All Answers
How do I start sql from command line?
What are the types of variables use in pl sql?
What is AUTH_ID and AUTH_USER in pl/sql ?
what is clause? : Sql dba
Which is faster subquery or join?
Why schema is used in sql?
What is the difference between rename and alias?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is primary key and foreign key?
what are integrity rules?
How does pl sql work?
How many disk partitions should I have?
Why do we use view in sql?
How does cross join work in sql?
How do I remove all records from a table?
