Answer Posted / deepa

For Example

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)

Explain stored procedure?

1042

---

what's sql server? : Sql server database administration

983

---

What is postgresql server?

985

---

What the different types of Replication and why are they used?

1055

---

How do you create a clustered index?

1042

---

How to rebuild all indexes on a single table?

1048

---

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1375

---

How do you check sql server is up and running?

982

---

Can we return Data from 4(more than 1) tables in stored procedure?

1047

---

How to convert a table data in XML format in sql server?

2529

---

What is table-valued sub query?

955

---

What is ssl in sql server?

1066

---

What is difference statement and preparedstatement?

972

---

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

121

---