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

how many columns can be used for creating index? : Sql dba

932

---

How to download oracle sql developer?

1087

---

What is the difference between function, procedure and package in pl/sql?

1227

---

What is trigger in flip flop?

1002

---

how many ways to get the current time? : Sql dba

991

---

What are hotfixes and patches?

933

---

What is procedure explain with example?

941

---

What are properties of the transaction?

993

---

What is before trigger?

990

---

what is the syntax used for partition in tsql? : Transact sql

998

---

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1064

---

Show the two pl/sql cursor exceptions.

1169

---

Why functions are used in sql?

975

---

What are few of the schema objects that are created using PL/SQL?

1016

---

How can you fetch first 5 characters of the string?

998

---