Answer Posted / meher

1. To get the duplicate records.
Use group by clause to the column on which you want to
check the duplicates records.
syntax:
select column_name, count(*) from table_name group by
column_name having count(*) >1

2. To delete the duplicate records.
syntax:
delete from table_name where rowid in (select max(rowid)
from table_name group by column_name having count(*)>1 )

This will work.
Please let me know in case of any issues.

Explain the purpose of indexes?

981

---

Define compound operators?

920

---

How many ways to create table-valued functions?

992

---

Which sql server table is used to hold the stored procedure script?

950

---

How to create a new schema in a database?

1151

---

What is dirty read?

1083

---

where the connection string store in the database

2073

---

What is report server project?

147

---

Which are the olap features?

960

---

How to create a view using data from another view?

954

---

How to recover from sql injection? : sql server security

1023

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2071

---

Can sql server 2016 run on windows 7?

922

---

Explain isolation levels that sql server supports?

1044

---

Is oracle faster than sql server?

957

---