Answer Posted / rama krishna

This will help u a lot bcz dynamically it will delete
duplicates



create table tbl1 (col1 int)





insert into tbl1 values(1)
insert into tbl1 values(1)
insert into tbl1 values(1)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(2)
insert into tbl1 values(3)
insert into tbl1 values(3)


select * from tb1


set rowcount 1
select 'start'

while @@rowcount > 0
delete a from tbl1 a where (select count(*) from tbl1 b
where a.col1 = b.col1)>1
set rowcount 0
select * from tbl1
set nocount off

What is sqlcmd?

961

---

Find nth lowest salary or get nth lowest salary?

965

---

What is bcnf normalization form?

1064

---

What do you mean by an execution plan?

1051

---

What are the main sources of data?

1036

---

In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1926

---

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1056

---

Explain transaction server isolation?

980

---

Can you pass expressions to stored procedure parameters?

970

---

What are differences in between sql server 2012 and sql server 2016?

978

---

How to create view in stored procedure sql server?

958

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

1023

---

If no size is defined while creating the database, what size will the database have?

923

---

What are logical database components? : SQL Server Architecture

959

---

How you can minimize the deadlock situation?

980

---