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

What is Trigger in Oracle?

1179

What is the database name in oracle?

1022

Explain the use of grant option in exp command.

1067

What are the numeric comparison operations?

1121

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2210

What are the attributes of the cursor?

1004

What is data block in Oracle?

1118

What is columnar storage what is the advantage?

1066

How to connect to a local oracle 10g xe server?

995

Explain the types of exception?

1147

Oracle

2380

What are the execution control statements in oracle?

1098

What is set operator oracle?

986

master table and child table performances and comparisons in Oracle ?

2138

Explain what are the advantages of views?

1069