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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anybody tell me about complicated object you have created

3222


What Is Snow Flake Schema?

1206


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

2155


What is a fantrap in business objects?

1170


is it possible to export the webi reports to crystal reports?with out using businessview?

2289


What is object stores?

984


What is the dense rank?

1231


What is difference between custom hierarchy and report based hierarchy?

1018


Give some information on report bursting?

993


What we need to discuss with designer before starting the universe designing.

2251


any difficulitis have you phase while creating bo reports and how did u solve it

3450


How can you first report in Business Objects by using broadcast agent?

3061


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

1065


Which command using Query Analyzer will give you the version of SQL server and operating system ?

5063


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1051