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 relational database?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is the difference between formal parameters and actual parameters?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to run the anonymous block again?
Can objects of the same schema reside in different tablespace?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to update values on multiple rows in oracle?
What do you understand by database schema and what does it hold?
What are the advantages of oracle 12c?
How to use windows user to connect to the server?
What is raw datatype?
What is memory advisor in Oracle?
How to sort the query output in oracle?
What are the database administrators utilities available?