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
- 30153 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / pratdeor
Select ename from table where sal IN
(select Max(sal) over (partition by Deptno) as mxs from table) and Deptno IN (10,20);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between nvl function, ifnull function, and isnull function?
Is trigger a stored procedure?
How many times can we commit in a loop?
Can there be 2 primary keys in a table?
What is the difference between inner join and left join?
Is sql a programming?
What is a clob in sql?
What is a constraint? Tell me about its various levels.
How many indexes can be created on a table in sql?
How do you clear the screen in sql?
How to change the order of columns in Oracle SQL Plus ?
Can a table have no primary key?
Where is all the data on the internet stored?
List the ways to get the count of records in a table?
What is trigger point?
