How can we delete Duplicate row in table?

0 Answers   Wipro,

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What is query cost in sql server?

0 Answers  

---

what do you understand by change data capture?

0 Answers  

---

Will sql server 2005 allow you to reduce the size of a column?

0 Answers  

---

What is a Join and explain its types?

0 Answers  

---

Explain Normalization and DE normalization

0 Answers   iNautix,

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

How to delete duplicate rows from table except one?

0 Answers  

---

How do you run a trace?

0 Answers  

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---