Interested to Buy Any Domain ? << Click Here >> for more details...
consider a table which contain 4 columns,ename,eno,sal and
deptno, from this table i want to know ename who having
maximum salary in deptno 10 and 20.
- 24 Answers
- 30188 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / rohan
select empno from emp where (sal,deptno) in ( select max
(sal),deptno from emp where deptno in (10,20) group by
deptno)
| Is This Answer Correct ? | 13 Yes | 6 No |
Post New Answer View All Answers
How can we debug in PL/SQL?
What is pl sql package?
How to get list of all tables from a database?
What is the best partition size for windows 10?
Explain commit, rollback and savepoint.
What are sql built in functions?
How to add a column ‘salary’ to a table employee_details?
Why are indexes and views important to an organization?
Show how functions and procedures are called in a pl/sql block.
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
What do you think about pl/sql?
Why do we create stored procedures & functions in pl/sql and how are they different?
What are the sql versions?
how many columns can be used for creating index? : Sql dba
How can we implement rollback or commit statement in a trigger?
