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

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

917

What are the limitations oracle database 10g xe?

974

Explain an index?

1089

What is a nested table?

1000

Can a parameter be passed to a cursor?

1049

Difference between cartesian join and cross join?

955

how to make an oracle object

2289

What is raw datatype in oracle?

1049

How can we find out the duplicate values in an oracle table?

992

How does Oracle guarantee data integrity of data changes?

2330

How to get execution statistics reports on query statements?

1004

How to call a sub procedure?

1034

How to assign values to variables?

1042

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

1015

How to define a variable of a specific record type?

1014