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

Which type of cursor is used to execute the dml statement?

995

---

What is the difference between left outer join and left join?

1034

---

Is join same as left join?

1080

---

What is data types in sql?

1070

---

Can dml statements be used in pl/sql?

1123

---

What is the difference between nested table and varray?

1050

---

Who is the owner of mysql database?

1105

---

How do I upgrade sql?

1048

---

What is difference between stored procedures and application procedures?

1063

---

Which version of sql do I have?

1109

---

What is trigger with example?

1168

---

How do you delete duplicates in sql query using rowid?

989

---

what is rollback? : Sql dba

1179

---

What does varchar include?

991

---

What is the advantage of index in sql?

1014

---