how to find the second highest salary from emp table?
- 211 Answers
- 322082 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 / nirjesh pandey
select salary from employee order by salary DESC LIMIT(1,1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is nosql db?
What is pls_integer in pl sql?
Is primary key clustered or nonclustered?
Explian rowid, rownum? What are the psoducolumns we have?
Does sql use python?
What is numeric function sql?
What are the uses of sysdate and user keywords?
What is a constraint? Tell me about its various levels.
What is minus?
What does the file extension accdb stand for?
What is the purpose of the primary key?
what are integrity rules?
What are packages in pl sql and also explain its advantages?
what are local and global variables and their differences? : Sql dba
What is not in sql?
