Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Can we create universe with no cache??

2441


What Is The Difference Between Oltp And Olap?

1059


Explain which versions are used in the bo dashboard work?

1038


What is the profile and package?

2248


Is there any other repository domains rather than universe, security, document?

997


What are the steps to do to use alerts in bo?

1321


Explain is there any other repository domains rather than universe, security, document?

1003


Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1827


explain in detail about type 3?

952


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1091


How many universes can be created in a project?

974


how many reports have u created ? explain a few.

2031


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

10252


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

965


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)?

1082