Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete the duplicate colums in a sql table ?
- 3 Answers
- 8097 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
Did you face any problems while creating reports? Name? Solutions?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain about a tricky situation for which you found a very simple solution?
what are the day to day activities of BO administrator ?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
How can you first report in Business Objects by using broadcast agent?
What Is The Difference Between Oltp And Olap?
When to use local filter and when to use global filter?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How were the reports scheduled and how to resolve unexecuted documents?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
What Is Snow Flake Schema?
