How to select the name of employee who is getting maximum
sal with out using subquery
Answer Posted / shan
select ename,max(sal)from emp
group by ename
| Is This Answer Correct ? | 0 Yes | 8 No |
Post New Answer View All Answers
Why do we need oracle client?
What is pragma autonomous transaction in oracle?
What is the minimum client footprint required to connect c# to an oracle database?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
Where are the settings stored for each instance in oracle?
What are dml statements in oracle?
What is the quickest way to export a table to a flat file?
How to get a list of all background sessions in the database?
How to rename a tablespace in oracle?
Can I create users through internet explorer in oracle 10g?
What is set verify off in oracle?
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?
What are the attributes of cursor?
What is a subquery in oracle?
What are the different windows events activated at runtime ?