Answer Posted / anil kumar karasi

1.
Select from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);


2.
Delete from <table name A>
where rowid > (select min(rowid) from <table name B>
where A.keyvalues=B.keyvalues);

Is sql server difficult to learn?

871

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

1067

---

What does nvl stand for?

913

---

How to use order by with union operators in ms sql server?

977

---

Define full outer join in sql server joins?

918

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

917

---

Define right outer join?

938

---

What are different types of collation sensitivity?

949

---

How to use subqueries with the in operators in ms sql server?

1024

---

How to create a scrollable cursor with the scroll option?

942

---

What is transaction server auto commit?

1001

---

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

945

---

Explain multiserver query

972

---

how to use DTS package in 2000,2005,2008 in sql server

1797

---

How can I create a report based on a query? : sql server management studio

978

---