How to delete the duplicate colums in a sql table ?
- 3 Answers
- 7240 Views
- IBM, I also Faced
- E-Mail Answers
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
Can we configure two instances of CMS pointing to two different CMS system databases?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is top business?
Can more than 1 metric be applied on an analytic in business objects?
Is there any other repository domains rather than universe, security, document?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Which command using Query Analyzer will give you the version of SQL server and operating system ?
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 report template in b.o?
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 ?
When to use local filter and when to use global filter?
Difference between zabo and webi?
Explain is there any other repository domains rather than universe, security, document?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
U r project in which stage in implementation?
