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 types of dbms?

539

---

How many triggers can be applied on a table?

495

---

Explain the difference between 'between' & 'and' operators in sql

521

---

what is blob? : Sql dba

555

---

Explain select statements in sql?

575

---

---

what is cross join? : Sql dba

560

---

What are inbuilt functions in sql?

586

---

Is pl sql still used?

498

---

Can we edit a view in sql?

535

---

How do I find duplicates in sql?

493

---

Can we perform dml on view?

545

---

Is json a nosql?

527

---

what is a unique key ? : Sql dba

533

---

What are different categories of sql commands?

625

---

What is the difference between syntax error and runtime error?

605

---