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 / nancy
Select ename from table where dept_no in ('10','20') group
by dpt_no
Is This Answer Correct ? | 4 Yes | 27 No |
Post New Answer View All Answers
How to run pl/sql statements in sql*plus?
What are some emotional triggers?
In a distributed database system, can we execute two queries simultaneously?
How do I view a sql database?
How many indexes can be created on a table in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Can we use two order by clause in query?
What are all the common sql functions?
what is the difference between $message and $$message? : Sql dba
What is a function in oracle pl sql?
Can there be more than one function with a similar name in a pl/sql block?
what is a unique key ? : Sql dba
What is procedure explain with example?
How are functions and procedures called in PL/SQL?
how is myisam table stored? : Sql dba