Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12292 Views
- Infogain, Symphony, I also Faced
- E-Mail Answers
Answer Posted / sujitpingale
Ans: select distinct(a.salary) from customers a where &n =
(select count(distinct(b.salary)) from customers b where
a.salary <= b.salary);
Enter value in inputbox. If you enter 1 then it will give
highest salary
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is clause?
What normalization means?
Can I join the same table twice?
what is the different between now() and current_date()? : Sql dba
What is the difference between stored procedure and view?
What is the difference between partition and index?
how to convert character strings to numeric values? : Sql dba
Explain 3 basic parts of a trigger.
What are different categories of sql commands?
What is set serveroutput on in pl sql?
What are the different schemas objects that can be created using pl/sql?
what is single byte over head in oracle..?
What is interval partition?
What is package in pl sql with an examples?
What is asqueryable?
