Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367847 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 / anurag kumar rai
select max(sal) from employee where sal<(select max(sal) from employee)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What if we write return in procedure?
What is sql procedures and functions?
What does the file extension accdb stand for?
What is query syntax?
Does normalization improve performance?
What is the use of procedures?
How many row comparison operators are used while working with a subquery?
How do I partition a table in sql?
What is a database trigger?
What is cursor and its types?
What is primary key secondary key alternate key candidate key?
How does join work in sql?
Is primary key a clustered index?
What is data type in database?
What is the difference among union, minus and intersect?
