Answer / 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

Answer / sudha511

select distinct * into #temp from sampletbl
delete sampletbl
insert into sampletbl
select * from #temp
drop table #temp

Answer / himmat

delete from table name
having count(column name)>1
group by column name

what are user defined datatypes? : Sql server database administration

0 Answers  

---

in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.

7 Answers  

---

Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

Is foreign key unique?

0 Answers  

---

What is nolock?

0 Answers  

---

Determine when to use stored procedure to complete sql server tasks?

0 Answers  

---

How to create stored procedures with parameters in ms sql server?

0 Answers  

---

How important do you consider cursors or while loops for a transactional database?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

In which files does sql server actually store data?

0 Answers  

---

Explain Trigger with an example?

2 Answers  

---