Answer Posted / chandran

There is a table like this: tablename: example


Name Age
chandran 23
ranjith 24
chandran 23

In this table the name:chandran and age:23 are the
duplicate records .so we need to delete this using this
sql statements


delete from example group by name,age having count>1

What is unpivot?

1011

---

How to create database with physical files specified in ms sql server?

993

---

What is self contained scalar sub query?

974

---

Why I am getting this error when renaming a database in ms sql server?

1052

---

What is always encrypted?

991

---

What is "scheduled jobs" or "scheduled tasks"?

979

---

Why would you use sql agent?

1261

---

What are the advantages of having an index on the sql server?

925

---

What is replication with database mirroring? : sql server database administration

1074

---

What are the types of joins in sql?

1126

---

How to provide values to stored procedure parameters in ms sql server?

1037

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1081

---

Define Unique Key?

1002

---

What is ddl and dml commands?

903

---

What is the order by used for?

1024

---