Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 11974 Views
- Infogain, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sujit pingale
Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);
It will ask you to enter number in input box which salary
you want to see
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to find 3rd highest salary of an employee from the employee table in sql?
Explain constraints in sql?
What is sap sql?
What is the difference between numeric and autonumber?
Can delete statement be rollbacked?
What is on delete set null?
Which version of sql do I have?
What does desc stand for?
How do I get sql certification?
What do you think about pl/sql?
Why sql query is slow?
What is pl sql and why it is used for?
What is procedure and function?
What are the different types of functions in sql?
What is optimistic concurrency control? : Transact sql
