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
- 24347 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / guest
Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=10) and deptno=10 union
Select emp_name from emp where sal =(Select Max(sal) from
emp where deptno=20)and deptno=20
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Can you have a foreign key without a primary key?
What is the difference between nested table and varray?
List out the acid properties and explain?
Explain the commit statement.
List different type of expressions with the example.
how to get a list of all tables in a database? : Sql dba
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
how to get @@error and @@rowcount at the same time? : Sql dba
What are tables and fields?
Explain what is a view?
What is the maximum number of triggers, you can apply on a single table?
what is the difference between primary key and unique key? : Sql dba
what is csv? : Sql dba
which tcp/ip port does sql server run on? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
