Answer / pritesh

By using temporary table, But it will delete exactly
duplicate rows NOT RECOMMANDABLE FOR HUGE TABLE. Query will
be.

SELECT DISTINCT * INTO #A FROM TABLE1

TRUNCATE TABLE TABLE1

INSERT INTO TABLE1
SELECT * FROM #A

Answer / arunkumar_mlx

WITH A
AS
(
SELECT ROW_NUMBER() OVER ( PARTITION BY
columnname_1,columnname_2 ORDER BY columnname_1) AS
duplicate FROM table_name
)
SELECT * FROM A WHERE duplicate>1
--DELETE FROM A WHERE duplicate>1

First select and you can find the row_number having more
than 1 rows.

Then delete them on comment of select stmt inside the
query..
decomment of that delete stmt will delete the duplicate
rows.

Answer / enis ertem

with DeleteDups as
(
Select * from TableA AS T1
where KeyCol <
(Select Max(Keycol) from TableA as T2
where t1.Id = T2.ID)
)

Delete from Delete Dups;

Answer / nittu

Delete from Tbl where Id NOT IN(
select Min(Id)
from tbl
Group By Colmn1,Column2)

Answer / surendra pal singh

delete from tablename where empname in (select empname from table name group by empname having empid>1)

where empname and empid are the columns of the table.
definately it will work

Answer / apps

select distinct eno,ename into temp_table from main_table
drop table main_table
-----
sp_rename temp_table,main_table

Answer / sundaravadivel g

Select top 1 * from table where a=1

select top 1* into table1 from table where a=1

delete from table

insert into table
select * from table1

What does it mean to normalize a database and why would you do it?

0 Answers  

Explain Active/Active and Active/Passive cluster configurations

2 Answers  

What are the main control-of-flow T-SQL constructs?

1 Answers  

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

Difference between drill down and drill through report.

0 Answers  

Why can there be only one clustered index and not more than one?

0 Answers  

What is a partitioned view?

0 Answers  

employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.

3 Answers  

What is database normalization?

7 Answers   Deloitte, Digicel, JPMorgan Chase, Verifone,

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

What is the use of RDBMS?

0 Answers   Wipro,