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
- 17444 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
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to name query output columns in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What are the built-in functions used for sending Parameters to forms ?
What is background process in Oracle?
What do you understand by a database object? Can you list a few of them?
Explain table?
How to increment dates by 1 in oracle?
What are the various oracle database objects?
What are the numeric comparison operations?
ABOUT IDENTITY?
How to lock and unlock a user account in oracle?
How to run queries on external tables?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the usage of save points in oracle database?
