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

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2253


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2147


explain in detail about type 3?

1066


8. How much supervision have you typically received in your previous job?

2307


What is the difference between datawarehousing and businessintelligence?

1140


What are all difference between business objects 6.5 and xi r2?

1088


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1360


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

6959


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1991


Differences between business objects and web intelligence reports?

1295


Explain what are the steps to do to use alerts in bo?

1124


What is the difference in creating filters in designer and business objects?

1078


Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2384


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

2470


Explain what task is 98% of the required work of a business analyst?

1171