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
- 26746 Views
- Mind Tree, I also Faced
- E-Mail Answers
Answer Posted / srilekha
select ename from table where sal=(select max(sal) from
table) and depetno in (10,20)
| Is This Answer Correct ? | 27 Yes | 20 No |
Post New Answer View All Answers
What are inner and outer joins examples of both?
Can a select statement fire a trigger?
what is a primary key? : Sql dba
What is compilation error in pl sql?
Can we join same table in sql?
Mention what is the use of function "module procedure" in pl/sql?
Is big data nosql?
What are stored procedures used for?
Does inner join remove duplicates?
What is memory optimized table?
What is the plv (pl/vision) package offers?
what are date and time data types? : Sql dba
Does view store data in sql?
What is data types in sql?
What is materialized view in sql?
