How to delete the duplicate colums in a sql table ?
- 3 Answers
- 7234 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subash
In this query the values will delete based on employee names
delete from emp a1 where rowid<(select max(rowid)from emp a2
where a1.ename = a2.ename group by a2.ename having count(1) >1);
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
is it possible to export the webi reports to crystal reports?with out using businessview?
How to open a universe with out using the Designer ??
Explain about a task that really tested your analytical abilities?
8. How much supervision have you typically received in your previous job?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
explain in detail about type 3?
Explain how to schedule the report in b.o?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain when we use aggregate awareness function in designer?
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)?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Which versions are used in the bo dashboard work?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
