Select ename from table where dept

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.

Question Posted / nancy

24 Answers
29530 Views
Mind Tree, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is sqlcontext?

986

What is the use of primary key?

952

What are the most important ddl statements in sql?

1025

What is sql clause?

993

How does sql*loader handles newline characters in a record? : aql loader

985

What is procedure explain with example?

894

Can cursors be part of a trigger body?

1586

List the ways to get the count of records in a table?

852

Does mysql support pl sql?

1098

What is a field in a database?

1005

Can we join two tables without common column?

929

How to assign sql query results to pl sql variables?

992

How do I turn a list into a table?

905

Can a commit statement be executed as part of a trigger?

996

How do I run a sql trace?

906