select first_name,count(*) from employees group by first

write a query to dispaly those name who is more than one in
student table?

example- in a student table sandeep kumar comes 4 times,
rakesh kumar comes 2 times, ajit kumar comes 1 times so
query will display sandeep kumar and rakesh kumar single
times.

Question Posted / gourav

11 Answers
17101 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / gourav

select first_name,count(*) from employees
group by first_name
having count(*)>1;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2222

What do you mean by merge in oracle?

996

How to start an oracle instance?

1023

Explain mutating triggers.

1034

how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?

5412

What is a schema in oracle?

1018

What do you mean by cdb and pdb in oracle 12c?

1062

How do I learn what codesets are available in oracle?

1040

What is instant client oracle?

1023

What does sharding mean?

1007

How to use attributes of the implicit cursor in oracle?

1011

Differentiate between translate and replace?

1123

How to count groups returned with the group by clause in oracle?

1079

What happens to the data files if a tablespace is dropped?

1061

How to export your own schema?

1007