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

List out the difference between commit, rollback, and savepoint?

1019

What is rich query?

961

How to get a create statement for an existing table?

949

Explain the use of indexes option in exp command.

1121

How to assign query results to variables?

1035

How to rename an index in oracle?

1101

Are truncate and delete commands same? If so why?

1130

What is an oracle table?

970

How to drop an existing table in oracle?

1047

How to assign a tablespace to a users in oracle?

1029

What is Trigger in Oracle?

1137

What is a snapshot log?

988

What is an oracle data file?

1083

what is the scenario where you take the database to NoArchivelog mode?

2305

Where do we use decode and case statements?

988