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
- 29500 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / praveen reddy.eddula
select ename from emp where sal in(select max(sal) from emp
where deptno in(10,20))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is an intersect?
What are the two virtual tables available at the time of database trigger execution?
What can sql server reporting services do?
Why primary key is required?
What is a data manipulation language?
Why is stored procedure faster than query?
What do you mean by query optimization?
Is big data nosql?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
When is the explicit cursor used ?
Can you call pl/sql package functions from within a fast formula?
what is meant by urlencode and urldocode? : Sql dba
what is heap table? : Sql dba
Define SQL and state the differences between SQL and other conventional programming Languages?
How do you break a loop in pl sql?
