Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 11 Answers
- 17093 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
What is data block in Oracle?
How to apply filtering criteria at group level in oracle?
Explain a synonym?
How to start an oracle instance?
What is the difference between sharding and partitioning?
Please explain oracle left join with an example?
What do you mean by group by clause?
how may join possible between (requisition with purchase order)
How to drop an existing view in oracle?
How would you change old and new values in an insert, delete and update triggers?
How to set up autotrace for a user account?
What is bulk load in oracle?
What are the differences between char and nchar in oracle?
How to fetch the row which has the max value for a column?
what is the difference between data migration and production migration.
