How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

How to list all tables in the database using odbc_tables()?

0 Answers  

---

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

---

Distinguish between commit and rollback?

0 Answers  

---

What are the new scripting capabilities of ssms? : sql server management studio

0 Answers  

---

How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,

---

How many types of dimensions are there and what are they? : sql server analysis services, ssas

0 Answers  

---

What is a unique key constraint?

0 Answers  

---

How do you simulate a deadlock for testing purposes

1 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.

5 Answers   IBM,

---