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
When to use local filter and when to use global filter?
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 ?
what is the difference b/w the refresh and buffered data?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
What task is 98% of the required work of a business analyst?
Explain what is the difference between slice and dice and cross tab report?
What is the difference between absolute and relative div positioning?
how to create reports on screech?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is difference between webi and infoview?
Explain in detail about type 2(scd),
Can we create universe with no cache??
Explain is there any other repository domains rather than universe, security, document?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server