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
30175 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 the difference between clustered and non clustered index in sql? : Sql dba

1105

What is a stored procedure in sql with example?

1104

How do you declare a variable in pl sql?

1007

what are all different types of collation sensitivity? : Sql dba

967

How would you convert date into julian date format?

988

Define sql delete statement.

988

How does postgresql compare to oracle/db2/ms sql server/informix?

1015

What is asqueryable?

948

What is sql clause?

1034

What are the differences between implicit and explicit cursors?

1046

What are the indexing methods?

1027

how to select unique records from a table? : Sql dba

1091

What is pl sql script?

1010

What is the use of procedures?

963

What is a sql schema used for?

1077