Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 367441 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 / sarojkant
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the update statement in sql
What is duration in sql profiler trace?
How many disk partitions should I have?
How can you know that statistics should be updated?
Does sql full backup truncate logs?
How to combine two stored procedures in sql?
What are different types of indexes?
What is the difference between a subquery and a join?
what are wild cards used in database for pattern matching ? : Sql dba
what are the types of subquery? : Sql dba
What are the benefits of pl/sql packages?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
tell me about various levels of constraint. : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
When sql appeared?
