Interested to Buy Any Domain ? << Click Here >> for more details...
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 is an oracle function?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
How to view the data files in the current database?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to drop an index?
What is hash cluster in oracle?
How can we create the complete backup of data in the oracle.
Difference between hot backup vs. Cold backup?
State some uses of redo log files?
Can multiple cursors being opened at the same time?
Difference between open_form and call_form in oracle.
What happens if variable names collide with table/column names?
How to use "in" parameter properly?
material view and view disadvantages?
