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 is dimension table? : sql server analysis services, ssas

0 Answers  

---

How to insert and update data into a table with "insert" and "update" statements?

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What is default port number for sql server 2000?

0 Answers  

---

Explain what is cte (common table expression)?

0 Answers  

---

what is a transaction? : Sql server database administration

0 Answers  

---

Is it true, that there is no difference between a rule and a check constraint?

0 Answers  

---

How do I partition a table in sql server?

0 Answers  

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

How to create dbo table in sql server?

0 Answers  

---

Which are new data types introduced in sql server 2008?

0 Answers  

---

How to create an index on a view?

0 Answers  

---