SELECT name FROM student_table GROUP BY name HAVING ( COUNT(name)

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

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

Answer Posted / abc

SELECT name FROM student_table
GROUP BY name
HAVING ( COUNT(name) > 1 );

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to delete all rows a table in oracle?

1078

What is backup in Oracle?

1011

What happens to indexes if you drop a table?

1179

What are the various types of snapshots ?

1037

What is the difference between alert log file and tarce file ?

2181

Explain the characteristics of oracle dba?

1133

What is oracle join syntax?

1008

how to join query for one source type is oracle another source type is sql server ?

2433

How do I escape a reserved word in oracle?

1211

In what script is snap$ created? In what script is the scott/tiger schema created?

2717

How to insert multiple rows with one insert statement in oracle?

1096

Can we write insert statement in function in oracle?

1101

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

1087

How to write a query with a left outer join in oracle?

1071

What is Undo Management Advisor in Oracle?

1110