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 three things do you consider to be the most important factors for a manager?
What are the steps to do to use alerts in bo?
how get the grand total in master-detail report?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What is the functional & architectural differences between business objects and web intelligence reports?
How we drill up week to month?
How to create Index to the table in the universe designer and how it improves the Query performence
What is a bo repository?
How to schedule the report in b.o?
Explain difference between zabo and webi?
Explain about a time when you discovered a more efficient way to do a work task?
What is a fantrap in business objects?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?