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 are the join types in tsql? : Transact sql

983

---

What is exception? What are the types of exceptions?

1035

---

What is primary and foreign key?

1018

---

how to use myisamchk to check or repair myisam tables? : Sql dba

914

---

What are dml commands?

943

---

What are sql triggers used for?

959

---

How exception handling is done in advance pl/sql?

920

---

What are the rules to be applied to nulls whilst doing comparisons?

1275

---

what are the non-standard sql commands supported by 'mysql'? : Sql dba

1045

---

What is the use of & in pl sql?

988

---

How do you remove duplicate records from a table?

887

---

what are the advantages of using stored procedures? : Sql dba

1061

---

Can we perform dml on view?

976

---

Why is pl sql needed?

877

---

Show the cursor attributes of pl/sql.

998

---