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
- 29526 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / kishore
select * from em where sal in (select max(sal) from em
where dno in (10,20) group by dno) and dno in (10,20)
where em = table name
dno = department number
sal = salary
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What are the basic techniques of indexing?
what is acid property in database? : Sql dba
What is the plv (pl/vision) package offers?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
Can we write ddl statements in functions?
Differentiate between syntax and runtime errors.
Are sql database names case sensitive?
Why do we use set serveroutput on?
Explain the working of foreign key?
What mean sql?
what is self join and what is the requirement of self join? : Sql dba
What is null in pl/sql?
What operating systems are supported by oracle sql developer?
what are the join types in tsql? : Transact sql
Mention what does the hierarchical profiler does?
