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 different types of statements supported by sql?

1165

---

What is an exception in pl/sql?

1094

---

What is the unique index?

1057

---

What is vector point function?

1057

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1077

---

What is the difference between pl and sql?

1096

---

What is user defined functions?

990

---

What is pl sql package?

1039

---

how can we find the number of rows in a table using mysql? : Sql dba

1089

---

What are stored procedures used for?

1004

---

What is the use of index in sql?

1020

---

Why use triggers in sql?

961

---

What is a sql schema used for?

1110

---

Is and as keyword in pl sql?

964

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3057

---