select ename,count(1) from student group by ename having count >1

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 / neha_gupta

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

Answer Posted / neha_gupta

select ename,count(1) from student
group by ename
having count >1

Is This Answer Correct ?

9 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to invoke the data pump import utility?

1079

How to define a cusotmer as a supplier in ORACLE R12

2168

What is background process in Oracle?

1049

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1848

Explain an exception?

918

What is control file used for?

1097

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?

2172

What is a tns file?

937

How to use group functions in the select clause using oracle?

1022

How to use subqueries with the in operator using oracle?

1029

What is bulk load in oracle?

1004

How to create a single index for multiple columns?

976

what is the scripts in data base?

2076

What is the exact use of Collections?

2094

Why does for update in oracle 8 cause an ora-01002 error?

932