Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373223 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 / chandu
select max(sal)from table name where sal<(select max sal
from table name)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does a join table need a primary key?
What is the difference between Union and Union all. Which is faster.
Is natural join same as inner join?
Is left join inner or outer?
is it possible to pass an object or table to a procedure as an argument?
What is program debugging?
How is use pl and sql?
What does the acronym acid stand for in database management?
What is sql integrity?
Explain what is a field in a database and record in a database?
Why do we use triggers?
What are the types of subqueries?
Can instead of triggers be used to fire once for each statement on a view?
What is the benefit of foreign key?
What is cross join sql?
