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 rdbms?

1043

---

How do I start and stop sql server?

1028

---

what is the difference between a primary key and a unique key? : Sql server database administration

1008

---

What are policy management terms?

985

---

Differentiate sql server reporting services vs. Crystal reports?

203

---

What is transaction server implicit?

1015

---

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

120

---

What is 'write-ahead log' in sql server 2000 ?

1063

---

What is meant by indexing files?

1043

---

What is difference between views and stored procedures?

992

---

What are the 7 disadvantages to a manual system?

986

---

can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1216

---

what's the difference between delete table and truncate table commands? : Sql server database administration

988

---

What is code near application topology?

279

---

What is the full form of ddl?

928

---