how to find the second highest salary from emp table?
- 211 Answers
- 321339 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 / vikas
select * from(select e.*,row_number() over (order by
e.salary desc)rn from Employee e)where rn between 1 and 2
order by rn
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how can we know the count/number of elements of an array? : Sql dba
What is delete command in sql?
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
What is the command used to fetch the first 5 characters of a string?
What is cte sql?
what is the difference between clustered and non clustered index in sql? : Sql dba
how can we find the number of rows in a table using mysql? : Sql dba
Why do we need unique key in a table?
What packages are available to pl/sql developers?
How do I view a procedure in sql?
Is foreign key mandatory?
What is procedure function?
What are the usages of sql?
Explain the significance of the & and && operators in pl sql.
Which nosql database is best?
