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
- 29552 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
Write the command to remove all players named sachin from the players table.
What is the purpose of a sql?
How do you modify a column in sql?
how many columns can be used for creating index? : Sql dba
Can a select statement fire a trigger?
how to convert character strings to dates? : Sql dba
Cite the differences between execution of triggers and stored procedures?
What is execute immediate?
what is text? : Sql dba
Why primary key is required?
Does asenumerable execute the query?
Which is better join or subquery?
what is the difference between undefined value and null value? : Sql dba
Does a user_objects view have an entry for a trigger?
Can you rollback after commit?
