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 |
Name two files used for network connection to a database.
Give two examples of referential integrity constraints.
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
0 Answers Punjab National Bank,
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
Explain the payment term in ar. : oracle accounts receivable
Compare and contrast TRUNCATE and DELETE for a table.
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
What is the mandatory setup in cyclecount ?
Name a tablespace automatically created when you create a database.