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
- 31268 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
Which join is like an inner join?
How does cross join work?
Is natural join and inner join same?
How many aggregate functions are available there in sql?
What are the benefits of triggers?
How do you remove duplicates without using distinct in sql?
Which sql statement is used to delete data from a database?
What is database migration?
What do you understand by case manipulation functions?
What is sql catalog?
what is the difference between a web-garden and a web-farm? : Sql dba
What is data manipulation language?
What is insert command in sql?
What is sql partition function?
What is difference between stored function and application function?
