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 the mandatory setup in cyclecount ?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
please send me oracle pl/sql exp resume. and also faqs...
A Table has 10,000 records,How can i get latest 10 dates from the table.so that i can only store those 10 records in to my Resultset Object,to reduce load on my app?
WHAT IS CARTESIAN PRODUCT?
How to update the simple views?give me example?if the table having 100 records and created a view on this table. if i can update the table then how to update the views
Are These Dff's Flexible?
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
Difference between negative and positive adjustments : oracle accounts receivable
Explain an ORA-01555
Give the reasoning behind using an index.
What are different types of transactions in ar? : oracle accounts receivable