Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 12497 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 are different types of triggers?
When do we use triggers?
What is a mutating table and a constraining table?
What is right join in sql?
Is left join same as join?
how do you control the max size of a heap table? : Sql dba
What is crud diagram?
What is the primary key?
What is the main difference between sql and pl/sql?
What are the types of sql commands?
what are tables and fields? : Sql dba
What is the default isolation level in sql server? : Transact sql
explain normalization concept? : Sql dba
Can we write ddl statements in functions?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
