Answer Posted / chandran.s

Table Name: Example

Name Age
chandran 23
ranjith 24
chandran 23

To delete one of the duplicate records use following query


delete from example where age in(select age from example
group by age having count>1)

Explain indexed views and partitioned view with their syntax.

1129

---

Difference between DELETE and TRUNCATE?

1044

---

The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio

1007

---

How do I find the default sql server instance?

931

---

Can you pass expressions to stored procedure parameters?

1023

---

What is CTE in SQL

937

---

What is intellisense?

1044

---

What is the server name for sql management studio?

1008

---

How do I start and stop sql server?

1012

---

What are the elements of dbms?

956

---

How to reaname table name without using sp_Rename in sql server..?

980

---

What is open database communication (odbc)?

1055

---

Is sql different from sql server?

1069

---

What are the differences between stored procedure and view in sql server?

1233

---

What do you understand by the denormalisation?

949

---