select student_name from student group by student

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 / abrar yaseen

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

Answer Posted / abrar yaseen

select student_name from student group by student_name
having count(OCCURANCE) > 1

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to download oracle database 10g xe?

958

How to upsert (update or insert into a table)?

950

How to insert a record into a table?

1019

What is the quickest way to export a table to a flat file?

917

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2899

Difference between inner join vs where ?

977

List out the types of joins.

1080

How a tablespace is related to data files?

1060

How to create a table index?

1060

What is the sid in oracle?

898

How to return top 5 rows in oracle?

986

Difference between cartesian join and cross join?

956

How to run create database statement again?

1076

How to create a stored procedure in oracle?

1026

How to create a new table by selecting rows from another table?

1016