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
- 24385 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / rashmi_raju
SELECT ename FROM emp WHERE sal =(SELECT MAX(sal) FROM emp
WHERE deptno=10)
UNION
(SELECT ename FROM emp WHERE sal =(SELECT MAX(sal) FROM emp
WHERE deptno=20))
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is write ahead logging in sql server?
how are mysql timestamps seen to a user? : Sql dba
what is the difference between blob and text? : Sql dba
What does pragma mean?
What version is sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What is meant by cursor in sql?
What is the difference between a subquery and a join?
What is a sql*loader control file?
Does pl/sql support create command?
What is optimistic concurrency control? : Transact sql
What is the use of sqlerrd 3?
Is null operator in sql?
Why is sql*loader direct path so fast?
What are two statement types in sql?
