Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12245 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
What is the difference between union and union all command?
Explain the purpose of %type and %rowtype data types with the example?
What is int identity in sql?
What is cartesian join in sql?
How many types of index are there?
which types of join is used in sql widely? : Sql dba
What is cursor status?
What are the types of records?
What does where 1/2 mean in sql?
How do you write a subquery?
What is varchar example?
Does pl sql work in mysql?
how do you control the max size of a heap table? : Sql dba
What is procedure and function in sql?
What are the different set operators available in sql?
