How to delete the duplicate colums in a sql table ?
Answer Posted / sathyasheelanbe
delete from tablename where rowid not in(select max(rowid)
from tablename group by primary key columnname)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is universe null
What is the functional & architectural differences between business objects and web intelligence reports?
what are the tables used in health care domain project and columns used in report?
What are the steps to be taken to schedule the report?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What would you consider as your biggest achievement and why?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
How many universes can be created in a project?
What are all difference between business objects 6.5 and xi r2?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What Is Snow Flake Schema?
how to create reports on screech?
What is the dense rank?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha