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
- 26755 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 is sql in mysql? : Sql dba
What is sql analyzer?
What are the types of keys?
what is error ora-03113: end-of-file on communication channel?
Is natural join same as inner join?
What is cte sql?
Are stored procedures compiled?
What is a parameter query?
What is cursor and its types?
What will you get by the cursor attribute sql%found?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
How do you modify a trigger?
What is nvl?
Does view contain data?
What is user defined functions?
