Answer Posted / kumar

sno names
1 arun
2 arun
3 arun
6 arun
7 bala
11 bala
12 guna
9 guna
14 guna
10 raj
13 raj

Table Name T1
Fields Names Sno,Names
Delete From t1 where sno not in
(select min(sno) from t1 group by names)

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2177

---

What is a synonym for manipulation?

954

---

What are examples of triggers?

1045

---

Explain how many types of relationship?

993

---

What is clustered index

973

---

How to call stored procedure using http soap?

1030

---

what is normalization? Explain different levels of normalization? : Sql server database administration

1257

---

List the data types available in mssql?

986

---

What is indexed view? How to create it?

958

---

In which tcp/ip port does sql server run? Can it be changed?

959

---

Some queries related to SQL

945

---

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

940

---

What happens when the SQL Azure database reaches Max Size?

109

---

When multiple after triggers are attached to sql table, how to control the order of execution?

1006

---

What is format parameter in ssrs?

140

---