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
29820 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 are the types of variable use in pl sql?

1034

In pl/sql, what is bulk binding, and when/how would it help performance?

965

Can a key be both primary and foreign?

960

What is latest version of sql?

1015

Is sql sequential or random?

995

How do you use collections in procedure to return the resultset?

2203

What is aggregate function in sql?

1004

what is a foreign key ? : Sql dba

1046

How many postgresql users are there, worldwide?

1023

What is use of trigger?

888

How to avoid duplicate records in a query?

971

what is error ora-03113: end-of-file on communication channel?

1119

how to convert character strings to dates? : Sql dba

1016

How is use pl and sql?

1021

What is $$ in sql?

960