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

What is the difference between pre-select and pre-query?

1230

List out the types of joins.

1173

How to use like conditions in oracle?

1072

How many data types are supported?

1089

What is the string concatenation operator in oracle?

1184

What is Reduced List of Values?

2184

What is a schema in oracle?

1027

How to create tables for odbc connection testing?

1128

What are the restrictions on external table columns?

1062

ABOUT IDENTITY?

2065

How to do a full database export?

1119

How to create an oracle database?

1059

What is the difference between a primary key & a unique key?

1099

What is an oracle user role?

992

Explain the features of oracle?

1059