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 document design in boxi,have u participate in that
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
What is difference between custom hierarchy and report based hierarchy?
Explain about alerts in bos, under what situation we need to use alerts?
Explain about a tricky situation for which you found a very simple solution?
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?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain about a time when you discovered a more efficient way to do a work task?
what will be the contents for a functional requirements specifications
Can anybody tell me what are the tuning problems?
Explain in detail about type 1?
What is thumbnail?
How to schedule the report in b.o?