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);

Explain about sql server login?

1093

---

Can sql server 2016 run on windows 7?

925

---

What is built-in/administrator?

1019

---

What is the difference between functions and scalar functions?

1215

---

What is the simplest way to create a new database in ms sql server?

1011

---

List out the difference between union and union all in sql server?

998

---

What is the full form of ddl?

929

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1060

---

How many types of triggers are there?

1070

---

What is the command used to check locks in microsoft sql server?

1047

---

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

1022

---

What is the difference between a clustered index and a non-clustered index?

991

---

How to Insert multiple rows with a single insert statement?

1058

---

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

913

---

How do database indexes work?

1015

---