Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aryasen vaikom
SELECT DISTINCT (a.sal)
FROM EMP A
WHERE 5= ( SELECT COUNT (DISTINCT (b.sal))
FROM EMP B
WHERE a.sal<=b.sal )
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What are the ways tablespaces can be managed and how do they differ?
How to omit columns with default values in insert statement in oracle?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is logical backup in oracle?
What is raw datatype?
Why is oracle so popular?
How to start your 10g xe server from command line?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to check your oracle database 10g xe installation?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the difference between sharding and partitioning?
How to load data from external tables to regular tables?
How can we find out the current date and time in oracle?
How to do paging with oracle?
How to add a new column to an existing table with a default value?
