How to find only %th Highest Sal
- 6 Answers
- 10038 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 oltp (online transaction processing)? : Sql dba
Is sqlexception checked or unchecked?
How to use transactions efficiently : transact sql
What is before trigger?
What is the use of primary key?
Can we commit in trigger?
what is sql? : Sql dba
Can we join more than 2 tables in sql?
What is crud stand for?
What is trigger in pl sql?
what are the authentication modes in sql server? : Sql dba
How do I run pl sql in sql developer?
how many values can the set function of mysql take? : Sql dba
Why do we use procedures in pl sql?
Which table is left in join?
