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
what are null values? : Sql dba
Show the two pl/sql cursor exceptions.
What is indexing in sql and its types?
How do I view a procedure in sql?
What is the benefit of foreign key?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
What is ttitle and btitle?
What is materialized view in sql?
How delete all data from all tables in sql?
Which certification is best for sql?
Is sql better than access?
Can you have more than one trigger on a table?
Sql technical questions
what is normalization? : Sql dba
Which type of cursor is used to execute the dml statement?