How to delete the duplicate colums in a sql table ?
Answers were Sorted based on User's Feedback
Answer / san
It's not at all possible to create duplicate columns in a
SQL table. The how can we delete the duplicate columns?
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Difference between scope of analysis in webi and in deski?
What task is 98% of the required work of a business analyst?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
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,
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
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)?
Ihave one report.Now i want to display that report as one row as one color and another row as another color.The entire report i need like that
Difference between Object varification and validation
How to open a universe with out using the Designer ??
How to restrict the user to refresh or Run the report only 1 time in BO?