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
Can we create universe with no cache??
What Is The Difference Between Oltp And Olap?
Explain which versions are used in the bo dashboard work?
What is the profile and package?
Is there any other repository domains rather than universe, security, document?
What are the steps to do to use alerts in bo?
Explain is there any other repository domains rather than universe, security, document?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
explain in detail about type 3?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How many universes can be created in a project?
how many reports have u created ? explain a few.
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What sort of existing documents should business analysts refer to when starting on a new project?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?