Interested to Buy Any Domain ? << Click Here >> for more details...
How to find only %th Highest Sal
- 6 Answers
- 11982 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 an exception in PL/SQL? What are the two types of exceptions?
What is the use of function "module procedure" in pl/sql?
Are dml statements autocommit?
what are the differences between binary and varbinary? : Sql dba
Enlist the characteristics of pl/sql?
What are types of joins?
What is the usage of sql functions?
Do we need to create index on primary key?
What is difference between table and view?
What is mutating error in pl sql?
Can we use view in stored procedure?
what is the use of set statement in tsql? : Transact sql
Is coalesce faster than isnull?
Is sqlite thread safe?
What is difference between my sql and sql?
