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
- 16618 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 is the difference between alert log file and tarce file ?
Does oracle charge for java?
what's query optimization and without use of IN AND Exist can we get another way data from query
How index is implemented in oracle database?
Explain the difference between sql and oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What are the numeric comparison operations?
What is a subquery in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
How to best split csv strings in oracle 9i?
When do I need to use a semicolon vs a slash in oracle sql?
What are the execution control statements in oracle?
what is insert all statement in sql
what is port in oracle? how is it related to database application.
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
