Answer Posted / victor

this can help if you want to keep only different records

create table test
(
id int,
name varchar(20)
)

insert into test VALUES(1,'test')
insert into test VALUES(2,'test')
insert into test VALUES(2,'test')
insert into test VALUES(3,'test')
insert into test VALUES(4,'test')
insert into test VALUES(5,'test')
insert into test VALUES(6,'test')
insert into test VALUES(7,'test')
insert into test VALUES(7,'test')
insert into test VALUES(7,'test')



select * from test order by 1

while @@rowcount != 0
begin
delete top (1) test where id in
(
select id
FROM test
GROUP BY id having count(id)>1
)
end

select * from test order by 1


-- At the end you will have only differents IDS

What is the difference between row_number and dense_rank?

934

---

What is a trigger? Why we need it?

1050

---

What happens if null values are involved in arithmetic operations?

1041

---

Explain atomicity?

1123

---

What is database dimension? : sql server analysis services, ssas

1128

---

What is indexing explain it with an example?

1065

---

Is natural join and equi join same?

1026

---

Explain transaction server distributed transaction?

1032

---

What languages bi uses to achieve the goal?

1050

---

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

2122

---

Can a table have 2 primary keys?

1029

---

Can we use max in where clause?

979

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

1182

---

How to provide default values to function parameters?

1216

---

How do indexes help, types?

1011

---