Answer / vnreddy

create table sampletbl(id int,name varchar(100))

insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(2,'bb')
insert into sampletbl values(2,'bb')

with cte as(
select ROW_NUMBER() over (partition by id order by id) as r_no,* from sampletbl)
delete from cte where r_no>1

select * from sampletbl

Answer / sudha511

select distinct * into #temp from sampletbl
delete sampletbl
insert into sampletbl
select * from #temp
drop table #temp

Answer / himmat

delete from table name
having count(column name)>1
group by column name

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

How do I debug a stored procedure in sql server?

0 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

What is blocking?

0 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

---

What is shrink log file?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

What are the differences between sql server and mysql.

0 Answers  

---