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
- 16913 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
What the is the diff between local index and global index. give some example.
How to login to the server without an instance?
How can we find out the duplicate values in an oracle table?
Is oracle a language?
Why do you use stored procedures and state some of its disadvantages?
What are the oracle built-in data types?
What is dynamic proxy?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What happens if you set the sga too low in oracle?
Is there a function to split a string in plsql?
How to connect the oracle server as sysdba?
What is concurrency in oracle?
Where do we use decode and case statements?
How to create an oracle testing table?
What are the execution control statements?
