Answer Posted / vnreddy

create table sampletbl(id int,name varchar(100))

insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(1,'aa')
insert into sampletbl values(2,'bb')
insert into sampletbl values(2,'bb')

with cte as(
select ROW_NUMBER() over (partition by id order by id) as r_no,* from sampletbl)
delete from cte where r_no>1

select * from sampletbl

Explain the flow of creating a cube? : sql server analysis services, ssas

1100

---

Do comments need to go in a special place in sql server 2005?

910

---

what's the difference between delete table and truncate table commands? : Sql server database administration

1038

---

Explain system views?

1130

---

How column data types are determined in a view?

1006

---

How to find Duplicate Records In table?

1070

---

Can you explain what are various ways to enhance the ssrs report?

1066

---

what is create database syntax? : Sql server database administration

1159

---

Explain powershell included in sql server 2008?

1114

---

Which sql server table is used to hold the stored procedure script?

1004

---

Explain in brief how sql server enhances scalability of the database system?

1025

---

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

152

---

According to you what goes into making the best database administrator? : sql server database administration

1022

---

What is a linked server in sql server?

1130

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1085

---