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
16945 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

Explain the use of tables option in exp command.

1098

What is the difference between a primary key & a unique key?

1072

Explain about achiever in sql?

1009

Explain about integrity constraint?

1109

Explain oracle 12c new features for developers?

1024

Where do we use decode and case statements?

988

Can you have more than one content canvas view attached with a window ?

2314

How to run create database statement?

1011

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1829

Is there a function to split a string in plsql?

1039

What language does oracle use?

1083

What do you understand by database schema and what does it hold?

1221

How many types of segments in Oracle?

1054

What is proxy method?

960

What is the relation of a user account and a schema in oracle?

1067