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 are the differences between decimal and float in ms sql server?

0 Answers  

---

What is outer join in sql server joins?

0 Answers  

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Can you explain what is indexed view? How to create it?

0 Answers  

---

What is the difference between osql and query analyzer?

0 Answers  

---

Difference between Inner vs outer joins?

0 Answers  

---

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

2 Answers  

---

How do I view views in sql server?

0 Answers  

---

Do you know what is similarity and difference between truncate and delete in sql?

0 Answers  

---