select distinct NM from ( (select name from 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 / cheeku

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

Answer Posted / cheeku

select distinct NM from
(
(select name from student_tbl M where exists
(select 1 from student_tbl S where
S.name = M.name and
S.rowid <> M.rowid)
)NM;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Name the various constraints used in oracle?

969

What is varray?

1034

WHAT IS ecc 6.0

2101

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

1062

How many types of tables are there in oracle?

1003

Why do you create or replace procedures rather that drop and recreate.

945

How to assign data of the deleted row to variables?

1013

What is a proxy class?

967

Â How to use an oracle sequence generator in a mapping?

1017

Explain the dml?

918

How to convert characters to times in oracle?

954

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2248

Is java required for oracle client?

922

How to create a new user account in oracle?

952

What is a connect identifier?

981