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 the difference between union and group?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
What is the functional & architectural differences between business objects and web intelligence reports?
What is report template in b.o?
Explain is data mart?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Can we create universe with no cache??
Explain how to execute the plsql procedure from the report by clicking with mouse?
Can we configure two instances of CMS pointing to two different CMS system databases?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Which versions are used in the bo dashboard work?
Explain what are the steps to be taken to schedule the report?
Can anybody tell me what are the tuning problems?
What is Indexing? how did u implement indexing?