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
17457 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 rollback the current transaction in oracle?

1104

What is the difference between primary key and unique key and foreign key in oracle?

1035

What to do if the startbd.bat failed to start the xe instance?

1126

What is a package ? What are the advantages of package ?

1136

How would you go about verifying the network name that the local_listener is currently using?

2107

How to set up autotrace for a user account?

1112

How to define a sub function?

1199

What is a user account in oracle?

1170

What is a nested table?

1111

How to load data from external tables to regular tables?

1102

What is procedure overloading in oracle?

1113

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

Name the various constraints used in oracle?

1080

How to use subqueries with the exists operator in oracle?

1069

Can a formula column be obtained through a select statement ?

2380