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
Explain how we drill up week to month?
what is document design in boxi,have u participate in that
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Which command using Query Analyzer will give you the version of SQL server and operating system ?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to restrict password to a user while sending a document in .pdf format
Is there any other repository domains rather than universe, security, document?
Explain how many universes can be created in a project?
What three things do you consider to be the most important factors for a manager?
Give some information on report bursting?
How to execute the plsql procedure from the report by clicking with mouse?
What is package in BO
Differences between business objects and web intelligence reports?