Answer Posted / manjeet kumar

delete from table_name where column_name='value' and rowid
not in (select max(rowid) from table_name where
column_name='value');

e.g. create table duplicate (name varchar(15), rollno number
(10));

insert into duplicate (name,rollno) values ('mkumar',2);
insert into duplicate (name,rollno) values ('mkumar',2);

delete from duplicate where name='mkumar' and rowid not in
(select max(rowid) from duplicate where name='mkumar');

what is the different types of backups available in sql server? : Sql server database administration

917

---

What do you understand by integration services in sql server?

955

---

What are security principals used in sql server 2005?

971

---

what is checksum in sql server.........???

1675

---

What are the database objects? : SQL Server Architecture

1036

---

How do you delete duplicate rows in sql server?

950

---

What is update_statistics command?

1057

---

What are the different sql server versions?

970

---

How to check if a table is being used in sql server?

958

---

Explain what is dbcc?

1000

---

How do I find the query plan in sql server?

946

---

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1979

---

What is attribute? : sql server analysis services, ssas

1013

---

Explain having clause?

955

---

What happens if time-only values are provided as date and time literals?

1004

---