Answer Posted / karthik
select distinct sal from emp a where 2 = (select count
(distinct sal) from emp b where a.sal <= b.sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you assign multiple query result rows to a variable?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are oracle functions?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is tns name?
What do you mean by merge in oracle and how can you merge two tables?
how to do daily transactions with out sql* loader control file regesterd in apps?
how can we store any pdf file in oracle
What are the execution control statements in oracle?
What is a dynamic performance view in oracle?
Explain the use of owner option in exp command.
How do I start tns listener?
what is dynamic SGA and static SGA
How to create an oracle testing table?
How are extents allocated to a segment?
