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
- 31260 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / avinash
select ename from emp where sal in(select max(sal) from
emp) and deptno in(10,20)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In a distributed database system, can we execute two queries simultaneously?
How to find 3rd highest salary of an employee from the employee table in sql?
what are integrity rules?
How to handle bulk data?
How can check sql version from command line?
Can you have more than one key in a database?
What is an implicit commit?
i have some prob lem to tell me about my self in interview first round ...
How do I count duplicates in sql?
What is a ddl command?
What does := mean in pl sql?
Write a query to find the names of users that begin with "um" in sql?
How many types of relationship are there?
What is cursor and why it is required?
Can we use joins in subquery?
