Answer Posted / chandran

There is a table like this: tablename: example


Name Age
chandran 23
ranjith 24
chandran 23

In this table the name:chandran and age:23 are the
duplicate records .so we need to delete this using this
sql statements


delete from example group by name,age having count>1

Explain system functions or built-in functions? What are different types of system functions?

1055

---

What are different types of constraints?

985

---

Can we do dml on views?

1027

---

what is spatial nonclustered index

1050

---

What is standby servers? Explain types of standby servers.

1067

---

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1180

---

How can we solve concurrency problems?

1112

---

What are the source of constraints?

998

---

How do I find the sql server version?

1096

---

How raid can influence database performance?

1097

---

Where can you add custom error messages to sql server?

1193

---

Why and when do stored procedure recompile?

1044

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8218

---

Explain “row_number()” in sql server with an example?

1062

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1056

---