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 transaction server auto commit?

1060

---

What is cursors?

1186

---

Please explain go command in sql server?

1051

---

What is the sql server 2000 version number?

1078

---

Define left outer join in sql server joins?

958

---

What is the difference between varchar and varchar(max) datatypes?

1073

---

What is default constraint in ms sql server?

1034

---

Can we take the full database backup in log shipping?

952

---

How do I uninstall sql server 2014?

934

---

How many databases can we create in a single server?

207

---

Which are the third-party tools used in sql server and why would you use them?

911

---

Explain user defined functions?

993

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1393

---

You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

1053

---

What is the use of for clause?

1118

---