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
Can we protect our pl/sql source code?
Explain self joins in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain the use of file option in exp command.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Explain the blob datatype?
Compare and contrast between sql and sql server and explain its various functions?
Explain the dml?
What is the maximum number of triggers that can be applied to a single table?
How to drop a stored procedure in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the different types of synonyms?
What is a table in oracle?
What is a sub query? Describe its types?
How to loop through a cursor variable?