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

What is an index. What are the types?

1165

---

How can sql injection be stopped? : sql server security

1104

---

Explain full-text query in sql server?

1054

---

What is a scheduled job or what is a scheduled task?

1012

---

What is cube dimension? : sql server analysis services, ssas

1050

---

What are the 2 types of classifications of constraints in the sql server?

1184

---

What is xml datatype?

1131

---

What is replication with database mirroring? : sql server database administration

1152

---

What is default constraint in ms sql server?

1106

---

Can sql server 2016 run on windows 7?

965

---

What are the different authentication modes in sql server?

1168

---

How to select some specific columns from a table in a query in ms sql server?

1050

---

What is read committed?

1175

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1174

---

What is sql server profiler?

1062

---