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
- 30555 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / partha
Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 10 order by sal desc) a where
rownum < 2
union
Select emplid, sal from (select emplid, sal from
emp_sal_tbl where deptid = 20 order by sal desc) a where
rownum < 2
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the qualities of 2nf?
How do I pipe the output of one isql to another?
What is orm in sql?
What is the difference between the implicit and explicit cursors?
What is hibernate and its relation to sql?
What does select count (*) mean in sql?
what is union? : Sql dba
What are the two characteristics of a primary key?
what is a field in a database ? : Sql dba
What is dbo in sql?
What is the use of index in hive?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What is a rank in sql?
What is sqlcontext?
