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
- 24377 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 is the use of partition by in sql?
What is spool?
explain access control lists. : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What is dbo in sql?
Does asenumerable execute the query?
What is difference between pls_integer and integer?
What is delete command in sql?
Is sql workbench free?
Is join an inner join?
What are the sql aggregate functions?
What does := mean in pl sql?
how to enter binary numbers in sql statements? : Sql dba
What is the basic structure of an sql?
What is query syntax?
