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

How to edit table in sql server 2017?

919

---

How to loop through returning rows?

1025

---

What is difference between equi join and natural join?

1028

---

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1084

---

How can you know if the row fetched from cursor is still valid in underlying table?

993

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

954

---

Explain a join?

1057

---

What are the difference between primary keys and foreign keys?

961

---

How to connect Azure federated root database and apply federation in entity framework?

107

---

Which joins are sql server default?

997

---

How to create a login account in ms sql server to access the database engine using "create login" statements?

1128

---

How to change the ownership of a schema in ms sql server?

1176

---

How to rename databases in ms sql server?

1186

---

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

969

---

How to select an exiting database using mssql_select_db()?

980

---