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 is the difference between count(*) and count(1) ?

1028

---

What are the different types of data sources in ssrs?

188

---

How do I view a script in sql server?

980

---

What is difference statement and preparedstatement?

936

---

How to get the definition of a view out of the sql server?

942

---

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2448

---

What is ems sql management studio? : sql server management studio

1039

---

Do you know what are pages and extents? : SQL Server Architecture

944

---

What are a scheduled jobs or what is a scheduled tasks?

849

---

Explain how would you store your query in an SSRS report or a Database server?

114

---

How to find index size for each index on table?

963

---

Does partitioning improve performance sql server?

899

---

What are trace flags?

962

---

What is a field name?

915

---

What are sp_configure commands and set commands?

959

---