How to find only %th Highest Sal
- 6 Answers
- 10903 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
How to read xml file in oracle pl sql?
What is a pragma statement?
The select into statement is most often used to create backup copies of tables or for archiving records?
How many types of functions are there in sql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is the difference between clustered and non-clustered indexes?
What is time based sql injection?
Can we write dml inside a function in sql server?
define sql update statement ? : Sql dba
what is the difference between group by and order by in sql? : Sql dba
How to select all records from the table?
Does sql*plus have a pl/sql engine?
What does trigger mean in psychology?
What is the difference between local variables and global variables?
What does the sign mean in sql?
