select v_id from dup where rowid not in (select max(rowid) from dup group

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

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

Answer Posted / dheer

select v_id from dup where rowid not in (select max(rowid)
from dup group by v_id);

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the use of consistent option in exp command.

1077

What are joins, explain all types of joins?

2304

How can you use check constraints for self referential integrity?

979

What is merge statement used for?

1032

How do we create privileges in oracle?

1054

What is analyze command used for?

1082

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

1050

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1018

How to rename an index?

1081

What is flashback in Oracle?

1029

How to use like conditions in oracle?

1072

Can we call procedure inside function in oracle?

1105

What is tns name?

986

What is an oracle database table?

1022

What is the scope of a local variable?

1075