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.
Answer Posted / purushotham
select ename from table where sal in
(select max(sal) from table_name
where deptno in ('10','20')
group by deptno);
Is This Answer Correct ? | 16 Yes | 8 No |
Post New Answer View All Answers
Are pl sql variables case sensitive?
What are some emotional triggers?
What is auto increment in sql?
Does access use sql?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
What is materialized view in sql?
Sql technical questions
What are the subsets of sql?
How will you distinguish a global variable with a local variable in pl/sql?
How do you create a unique index?
How to place comments in pl/sql?
what is column? : Sql dba
How do you update f as m and m as f from the below table testtable?
What are joins in sql?