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
What do database buffers contain?
How to use null as conditions in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
What is BBED in Oracle?
What is the max number of columns in an oracle table?
What is a static data dictionary in oracle?
Why is oracle so popular?
How will you write a query to get a 5th rank student from a table student_report?
How to load data through external tables?
What are the advantages of oracle?
What is a named program unit?
Can we write dml statement in function in oracle?
What is a data dictionary and how can it be created?
What is oracle rownum?
Give the advantages and disadvantages of clusters.