How to delete the duplicate colums in a sql table ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between detect alias and detect context?

802


What is the difference between datawarehousing and businessintelligence?

829


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2836


Can we Save (save as) WEBI Doc as DESKI?

7533


Explain what sort of existing documents should business analysts refer to when starting on a new project?

781


(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

1241


What would you consider as your biggest achievement and why?

786


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1619


What is aggregate table and aggregate fact table ... Any examples of both?

791


how get the grand total in master-detail report?

2001


Explain when to use local filter and when to use global filter?

1143


Can you please send me the migration related issues .

1835


What is report template in b.o?

749


How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2168


What is the difference between the public object&schema object?

752