Answer Posted / anand

TABLENAME: testanand
DATA:
id vanme emailid age
-- ------ ---------- ------
1 Anand anand.kv@abc.com 29
2 Anand anand.kv@abc.com 28
3 Rajesh rajesh@abc.com 30
4 Rajesh rajesh@abc.com 31
5 Vinit vinit@abc.com 21
6 Vinit vinit@abc.com 25

DELETE FROM testanand WHERE id Not IN
(SELECT min(id) FROM testanand GROUP BY vname)

RESULTS:

id vanme emailid age
-- ------ ---------- ------
1 Anand anand.kv@abc.com 29
3 Rajesh rajesh@abc.com 30
5 Vinit vinit@abc.com 21

Is sql server 2016 free?

950

---

How to create a simple user defined function in ms sql server?

1029

---

Explain database normalization?

1235

---

What is the use of floor function in sql server?

1092

---

Explain external key management in sql server 2008

895

---

what is database replication? : Sql server database administration

1078

---

What is named query? : sql server analysis services, ssas

971

---

What are click through reports?

145

---

How to test subquery results with the exists operator?

1113

---

What is forward - only cursors / read only cursor?

1098

---

What are the different types of cursor?

1100

---

What will be the maximum number of indexes per table?

966

---

What is sql server 2000 work load governor?

1076

---

What is the use of set nocount on/off statement?

1101

---

What is efficiency data?

954

---