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
- 29553 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / john
select dept_id,ename max(sal) from employee where dept_id
in ('1','2') group by dept_id;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sql dialect?
what are all the common sql function? : Sql dba
Why is pl sql needed?
explain advantages of innodb over myisam. : Sql dba
What are the different schemas objects that can be created using pl/sql?
what is error ora-03113: end-of-file on communication channel?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Can we call dml statement in function?
What is the use of function in sql?
Define sql delete statement.
what is commit? : Sql dba
how tsql statements can be written and submitted to the database engine? : Transact sql
Why is there a need for sqlcode and sqlerrm variables?
Why we use cross join?
How does a trigger work?
