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)

How to round a numeric value to a specific precision?

1126

---

Does sql server use t sql?

1072

---

Explain the usage of floor function in sql server.

1024

---

Give a example to search fr a string in all stored procedure in sql server.

1064

---

what are the disadvantages of cursors? : Sql server database administration

1086

---

If we delete pack Spec what will be the status of pack Body ?

1524

---

Where the sql logs gets stored? : sql server database administration

1014

---

How can I get data from a database on another server?

1051

---

What is the difference between substr and charindex in the sql server?

1188

---

What is table join?

1172

---

What is the difference between a fill factor of 100 and 0?

1032

---

What are pessimistic lock and optimistic lock?

1142

---

How to insert multiple rows with a subquery?

1193

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

1044

---

What is “asynchronous” communication in sql server service broker?

1081

---