how to find the second highest salary from emp table?
- 211 Answers
- 322020 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 / surya
Select max(sal) from employee where sal not in(select max
(sal) from employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does select count (*) mean in sql?
How many types of relationship are there?
What is the use of index in hive?
What is data types in sql?
What is a left join?
how to convert numeric values to character strings? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
Is subquery faster than join?
Why does sql need a server?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are actual parameters and formal parameters?
How do I turn a list into a table?
Can we group by two columns in sql?
Why do we use triggers?
How do I view a sql trace file?
