how to find the second highest salary from emp table?
- 211 Answers
- 322224 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 / ruma
select *from emp order by sal desc limit 1,1
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is rowtype?
How many subqueries can be nested in a statement?
What is the purpose of my sql?
How do I make sql search faster?
explain mysql aggregate functions. : Sql dba
what happens if null values are involved in expressions? : Sql dba
What is difference between db2 and sql?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is sql in oracle?
Is vs as in pl sql?
What are different types of sql?
How does cross join work?
What is normalization? How many normalization forms are there?
What is sqlservr exe?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
