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
Is oracle a programming language?
How to define an anonymous procedure without variables?
Is it possible to split the print reviewer into more than one region ?
Why do we need integrity constraints in a database?
What are the limitations oracle database 10g xe?
What is execute immediate in oracle?
What do database buffers contain?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
Explain mutating triggers.
What is the minimum client footprint required to connect c# to an oracle database?
Is oracle a relational database?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What are the differences between interval year to month and interval day to second?
What do you mean by cdb and pdb in oracle 12c?