In my table i'm having the duplicate records with sequence
number and my requirement is when in new record is coming i
want to delete existing old record(onlyone i.e maintaing the
partial duplicate date )and add new record
Answers were Sorted based on User's Feedback
Answer / premnathselvaraj
selet distinct column name
from table
| Is This Answer Correct ? | 5 Yes | 14 No |
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
what is domain in database and its benefits?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is Restricted Mode of Instance Startup in Oracle?
what are the advantages of Oracle over other databases..? please give me reply...
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
as a technical developer in oracle applications which type errors feced in your experience sofar
Are These Dff's Flexible?
What is the sql query to find the employee who has Nth maximum salary?
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
0 Answers Pathway Technologies,
what is the difference between TRUNCATE and DELETE command in SQL
23 Answers ICICI, Saama Tech, SkyTech, TCS,