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

Is truncate autocommit in oracle?

1147

what is the scripts in data base?

2216

Explain the truncate in oracle?

1009

What is coalesce function?

1142

What is control file used for?

1298

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2341

What is the scope of a local variable?

1119

How to connect to the server with user account: sys?

1059

What is ADDM Advisor in Oracle?

1219

What is private procedure oracle?

1046

Explain cascading triggers.

1118

What is an external table?

1079

What is pragma autonomous transaction in oracle?

1121

How is it different from a normal table?

1080

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

1126