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.
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
Write the command to remove all players named sachin from the players table.
What are views in sql?
Which tcp/ip port does sql server run?
How is pl sql different from sql?
What is sqlservr exe?
tell us something about heap tables. : Sql dba
What is the basic structure of an sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
How delete all data from all tables in sql?
What is bind variable in pl sql?
How are functions and procedures called in PL/SQL?
What is sql partition?
What is cursor and its types?
Does a join table need a primary key?
What is before trigger?