Answer Posted / vinod singh kushwah

Delete From Tablename where(ID Not in (Select max(ID) from
Tablename Group by name))

Tablename :Friend

ID Name Age city
101 vinod 22 Gwalior
102 Pritesh 23 Gwalior
102 Pritesh 23 Gwalior
103 Arvind 24 Gwalior


Here Id-102 is repeated so friend if u want to delete this
duplicate raw Try Above code in Sql-sever

can you instantiate a com object by using t-sql? : Sql server database administration

1008

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

998

---

What are the joins in sql server? : sql server database administration

1016

---

What is the contrast amongst drop and truncate?

1038

---

How to generate create view script on an existing view?

993

---

Can an automatic recovery be initiated by a user?

1021

---

Can sub report data source be different from that of the parent report?

144

---

What does the on delete cascade option do?

1022

---

What is raid? : SQL Server Architecture

1189

---

What is partition, how will you implement it? : sql server analysis services, ssas

1061

---

How would you use user_constraints table in DB?

1012

---

What is the purpose of optimization?

1005

---

Define cross join in sql server joins?

1030

---

What is RAID? What are the different types of RAID configurations?

1137

---

How do I connect to sql server database?

1027

---