Answer Posted / brajesh

DECLARE temp CURSOR FOR SELECT id FROM cars1 c GROUP BY
c.id,c.name,c.year
DECLARE @id int
OPEN temp
FETCH next FROM temp
INTO @id

WHILE @@FETCH_STATUS=0
BEGIN
IF EXISTS (SELECT id FROM cars1 GROUP BY cars1.id
HAVING count(*)>1 AND id=@id)
DELETE TOP(SELECT count(*)-1 FROM cars1 WHERE
cars1.id=@id )FROM cars1 WHERE id=@id

FETCH next FROM temp
INTO @id
END

CLOSE temp
DEALLOCATE temp

Do you know what are acid properties of transaction?

923

---

Do you know the cursor types?

1124

---

Does sql server 2016 have ssms?

921

---

What do you mean by authentication modes in sql server?

1045

---

Does windows server 2016 come with sql server?

887

---

How sql server enhances scalability of the database system?

1137

---

What is the difference between the 2 operating modes of database mirroring?

1069

---

what is dbcc? : Sql server database administration

978

---

How can you list all the columns in a database?

891

---

You want to use a perspective in an mdx query. How do you select the perspective?

235

---

Name some of the open source software that you can use in alternative to SSR?

155

---

What do you mean by an execution plan? Why is it used? How would you view it?

885

---

What is entity data services?

1012

---

How to create prepared statements using odbc_prepare()?

1003

---

How to perform backup for certificates in sql server? : sql server security

1040

---