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 / 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 user defined functions? : Sql dba
Who is the owner of mysql database?
What is database white box testing and black box testing?
Which are sql * plus commands?
What are analytic functions in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what is msql? : Sql dba
what are null values? : Sql dba
What are the disadvantages of file system?
What is sql query limit?
What are tables in sql?
What is clustered index in sql?
What packages are available to pl/sql developers?
Can we call procedure in select statement?
How much does a sql dba make? : SQL DBA