Answer Posted / manjla

CREATE TABLE User_Details
(
UserID int ,
FName varchar (50),
MName varchar (50),
LName varchar (50),
Email varchar (50)
)

insert into User_Details values(1,'X','Y','Z','X@X.com')
insert into User_Details values(1,'X','Y','Z','X@X.com')
insert into User_Details values(2,'P','Q','R','P@P.com')
insert into User_Details values(3,'M','N','O','M@M.com')
insert into User_Details values(3,'M','N','O','M@M.com')

IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL
DROP TABLE #TempTable
CREATE TABLE #TempTable
(
UserID int ,
FName varchar (50),
MName varchar (50),
LName varchar (50),
Email varchar (50)
)
go
INSERT INTO #TempTable SELECT DISTINCT * FROM User_Details
go
TRUNCATE TABLE User_Details
go
INSERT INTO User_Details SELECT * FROM #TempTable

SELECT * FROM User_Details

What's the procedure?

665

---

what is the difference between where clause and having clause? : Sql dba

722

---

How to avoid duplicate records in a query?

747

---

explain access control lists. : Sql dba

714

---

What is execute immediate?

718

---

---

What is pivot query?

826

---

What are the built in functions of sql?

757

---

Define a temp table?

753

---

Where is sql database stored?

685

---

Why functions are used in sql?

703

---

What is scope and visibility in PL/SQL?

769

---

What is the order of sql select?

763

---

what is subquery? : Sql dba

773

---

Is it possible to create startup or shutdown trigger for on-schema?

778

---

Which table is left in left join?

714

---