how to find the second highest salary from emp table?
- 211 Answers
- 321518 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 / monika
Select salary from emp order by salary desc LIMIT 1,1;
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do you determine the current isolation level? : Transact sql
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Can I join the same table twice?
Should I use mbr or gpt?
What are the triggers associated with image items?
How do I count rows in sql?
Is sql dba a good career? : SQL DBA
What does trigger mean in psychology?
What are procedures used for?
How do I debug a stored procedure?
What is the max nvarchar size?
which tcp/ip port does sql server run on? : Sql dba
How do I run a program in pl sql?
What are the types of functions in sql?
What does select * from mean in sql?
