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

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

994

---

how to control the amount of free space in your index pages? : Sql server database administration

981

---

Do you know what is difference between index seek vs. Index scan?

896

---

Do you know what are acid properties of transaction?

908

---

What is data modification?

895

---

What authentication modes does sql server support?

1017

---

What are the purposes and advantages stored procedure?

886

---

How you can get a list of all the table constraints in a database?

906

---

Which command is used for user defined error messages?

1007

---

Can you use order by when defining a view?

914

---

How do I run a trace in sql server?

928

---

What is the language structure to add a record to a table?

961

---

How do I create a trace in sql server?

957

---

Explain the difference between cross join and full outer join?

921

---

What are types of scd? : sql server analysis services, ssas

972

---