Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12272 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
Explain alias in sql?
What is trigger with example?
What is attribute indicator in pl sql?
How do you modify a column in sql?
Enlist the characteristics of pl/sql?
what are enums used for in mysql? : Sql dba
what is a relationship and what are they? : Sql dba
How do you delete data from a table?
What is int identity in sql?
What is sql prepared statement?
What is the order of sql select?
What is the difference between explicit and implicit cursors in oracle?
How many row comparison operators are used while working with a subquery?
What is mutating error?
What is query execution plan in sql?
