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
- 26760 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
Does inner join return duplicate rows?
Explain what is a field in a database and record in a database?
What is difference between my sql and sql?
Is there a 64 bit version of ssms?
How to display the records between two range in Oracle SQL Plus?
How is a PL/SQL code compiled?
Sql technical questions
Could you please provide oca (oracle 10g) dumps for my certification ?
Where do we use pl sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
what are the different functions in sorting an array? : Sql dba
Who developed sql?
what are the advantages of sql ? : Sql dba
When can we use the where clause and the having clause?
Can we insert data in view?
