Answer Posted / prasant ojha

create a table tbl_info
(
name varchar(250),
age int
)
Enter values

'RAM',25
'SHYAM',34
'RAM',25
'GHANSHYAM',25
'RAM',25

//SQL QUERY TO REMOVE DUPLICATE RECORDS WITHOUR ANY KEY
with info_tbl as(

SELECT *,row_number() over(partition by name order by name)
as record_no from tbl_info
)
delete from info_tbl where record_no>1

When should you use an instead of trigger?

1036

---

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1284

---

How can you append an identity column to a temporary table?

1057

---

Where can you add custom error messages to sql server?

1193

---

How do I find the sql server version?

1096

---

Why should you use or avoid select * statements?

1096

---

How do I start sql server 2017?

1003

---

What is a coalesce function?

1270

---

What is the difference between upgrade and migration in sql server?

1166

---

What are the different SQL Server Versions you have worked on?

1071

---

Why we use the openxml clause?

1059

---

What is self contained sub query?

1133

---

What is acid mean in sql server?

1224

---

Is it possible to have clustered index on separate drive from original table location?

1031

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

8218

---