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.
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
How to use null as conditions in oracle?
Can I create users through internet explorer in oracle 10g?
Explain the use of tables option in exp command.
How to create additional tablespaces for an new database?
Explain the difference between replace() and translate() functions in oracle?
What is key preserved table?
Why cursor variables are easier to use than cursors?
How to select an oracle system id (sid)?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What is the difference between a primary key & a unique key?
How to update a table row with a record?
What are the attributes that are found in a cursor?
How to write text literals in oracle?
What is define in oracle?
Explain the use of rows option in imp command.