Answer Posted / dharmesh

your table look like this and want to delete duplicate
record

chandran 23
ranjith 24
chandran 23


delete top(1) from tablename where name='chandran' and
age=23

what's new in sql server 2016?

956

---

According to you what goes into making the best database administrator? : sql server database administration

980

---

What you can do to delete a table without the delete trigger firing?

973

---

Show Practically Sql Server Views are updatable?

1128

---

How can I create a report based on a query? : sql server management studio

1022

---

Can we hide the definition of a stored procedure from a use?

1228

---

What is self contained sub query?

1065

---

What do you understand by integration services in sql server?

968

---

How to drop an existing schema in ms sql server?

1105

---

How many types of triggers in sql server?

1034

---

What do you understand by triggers and mention the different types of it?

950

---

How to assign new column names in a view?

921

---

What is the full form of ddl?

928

---

What are the components of dbms?

954

---

How do I run sql server 2014?

1009

---