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
- 30464 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
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
how to use like conditions? : Sql dba
how to delete an existing column in a table? : Sql dba
What are the methods of filing?
how to shutdown mysql server? : Sql dba
How to add new employee details in an employee_details table with the following details
List the different type of joins?
Why are cursors used?
Is it possible for a table to have more than one foreign key?
Explain what is a column in a table?
How to install oracle sql developer?
What is not equal in sql?
What is the use of triggers?
what is online transaction processing (oltp)? : Sql dba
Which sql most popular?
