select stu_name from(select stu_name,count(stu_name) sc from stu

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

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

Answer Posted / seethal

select stu_name from(select stu_name,count(stu_name) sc from
stu_table group by stu_name)where sc > 1;

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do we display rows from the table without duplicates?

972

Which are the five query types available in oracle?

949

What is an Oracle Instance?

1121

How to drop a stored procedure in oracle?

1051

What are the limitations of check constraint?

1033

Which is better Oracle or MS SQL? Why?

4940

What's dateware house and what's clustor with practicle example

2175

why dont we assign not null constraint as table level constraint.

2737

What is a partition in oracle?

1121

What is a procedure in oracle?

1196

What is background process in Oracle?

1101

How to change system global area (sga) in oracle?

1013

How to define default values for formal parameters?

1044

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1349

How to define a record variable to store a table row?

1058