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
How to pass a cursor variable to a procedure?
What are the common oracle dba tasks?
What is the difference between substr & instr functions?
What is catalog in Oracle?
What is oracle latest version?
How to use like conditions in oracle?
Write a trigger example in oracle?
What are the predefined tablespaces in a database?
What the is the diff between local index and global index. give some example.
What privilege is needed for a user to delete rows from tables in another schema?
How many categories of data types?
What is clustered table in Oracle?
How to view the tablespaces in the current database?
How do I limit the number of oracle database connections generated by weblogic server?
What is java oracle used for?