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
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?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
explain in detail about type 3?
8. How much supervision have you typically received in your previous job?
What is the difference between datawarehousing and businessintelligence?
What are all difference between business objects 6.5 and xi r2?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
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 ?
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?
Differences between business objects and web intelligence reports?
Explain what are the steps to do to use alerts in bo?
What is the difference in creating filters in designer and business objects?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain what task is 98% of the required work of a business analyst?