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

What stored by the msdb? : sql server database administration

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

What all db objects can be found in MSDB database of a SQL Server instance?

2 Answers   Accenture,

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

How reterive duplicate value in SQL?

6 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

Explain primary key?

0 Answers  

---

hi,i want t0 knom d syntax for a super key with an example

1 Answers  

---

Define indexes?

0 Answers  

---

How to defragment table indexes?

0 Answers  

---

What is user stored procedure & it purpose?

4 Answers   Wipro,

---

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

0 Answers  

---