How do you remove duplicates without using remove duplicate stage?
Submitted by: AdministratorIn the target make the column as the key column and run the job.
delete table tablename where rowid not in Select * from tablename group by column name
Submitted by: Administrator
delete table tablename where rowid not in Select * from tablename group by column name
Submitted by: Administrator
Read Online ASP.NET 2.0 Job Interview Questions And Answers
Top ASP.NET 2.0 Questions
| ☺ | Web service support |
| ☺ | What types of data validation events are commonly seen in the client-side form validation? |
| ☺ | In A Page I have gridview with Options of select and delete using hyperlink when i am selecting any one of then it has to open another page how can it? |
| ☺ | How to rename a table using sql queries? |
| ☺ | Can a .NET web application consume Java web service? |
Top Dot Net Technologies Categories
| ☺ | MSF Interview Questions. |
| ☺ | .Net Architecture Interview Questions. |
| ☺ | ASP.Net MVC Interview Questions. |
| ☺ | Entity Framework Interview Questions. |
| ☺ | C# (Sharp) Programming Language Interview Questions. |
