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
- 31197 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / sonal
select * from (select ename, deptno,sal
from emp where deptno in(10 , 20)
order by sal desc)
where rownum < =1
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is a natural join sql?
What is the difference between numeric and autonumber?
What are the indexing methods?
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Why do we use joins in sql?
What are the two virtual tables available at the time of database trigger execution?
What is the basic structure of an sql?
How do you identify a primary key?
Can we use rowid as primary key?
What mean sql?
How do I run a sql query in pgadmin 4?
Why indexing is needed?
How does join work in sql?
Which are the different case manipulation functions in sql?
what is the difference between truncate and drop statements? : Sql dba
