Interested to Buy Any Domain ? << Click Here >> for more details...
how to check the 3rd max salary from an employee table?
- 23 Answers
- 37990 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ar
select c.emp_id,c.salary from (select rownum as
rn1,c.emp_id,c.salary from (select * from table_name ORDER
by salary DESC) b) c
where c.rn1 = n --(n=3)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are triggers and its types?
Which certification is best for sql?
What is multiple columns?
Can we connect to postgresql using sql developer?
How to create your own reports in sql developer?
Is sql dba a good career? : SQL DBA
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
How do I make sql search faster?
How to return an array from java to pl/sql?
How would you convert date into julian date format?
Define overloaded procedure?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is cost in sql execution plan?
Does truncate need commit?
What are different categories of sql commands?
