Answer Posted / brijesh darmwal, sandhya

DELETE FROM [MyDb].[dbo].[sandhya]
WHERE id
IN
(SELECT id
FROM
(SELECT MAX(id) as id,name,addr
FROM [MyDb].[dbo].[sandhya] GROUP BY name,addr having
count(id)>=2)
Tmp)

Why functions are used in sql server?

896

---

Explain what is analysis service repository?

926

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

938

---

What is the advantage of sql server?

987

---

What is the rdl file?

123

---

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

939

---

How do you identify a foreign key?

967

---

What is data set in report?

121

---

List out different types of normalizations in sql server and explain each of them?

886

---

What type of Index will get created after executing the above statement?

1045

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

913

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2333

---

Does server sql treat char as a variable-length or fixed-length column?

951

---

How to create user defined functions with parameters?

1164

---

What is inner join in sql server joins?

976

---