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 can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

497

---

what are the differences among rownum, rank and dense_rank? : Sql dba

534

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

587

---

How do I remove sql plus from windows 10?

560

---

What is the difference between microsoft sql and mysql?

502

---

---

Why sql query is slow?

573

---

Why partition by is used in sql?

548

---

define data blocks ? : Sql dba

539

---

Can you have more than one key in a database?

501

---

Show the two pl/sql cursor exceptions.

605

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

638

---

How bulk collect improves performance?

566

---

What are the different dml commands in sql?

580

---

Why stored procedure is faster than query?

513

---

What does the argument [or replace] do?

569

---