Answer Posted / bala_it243

using the following query u can delete the duplicate records.
but it is available only on SQL Server 2005.

with mytable as
(
select *, ROW_NUMBER() OVER(partition by id,myname order by
id desc) as RowNumber from test
)
delete from mytable where rownumber>1


"Have a Great Day"

Bala

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1436

---

What is indexing explain it with an example?

553

---

Explain partitioned view?

591

---

explain different levels of normalization? : Sql server database administration

523

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

590

---

---

How to see the event list of an existing trigger using sys.trigger_events?

571

---

What is the difference between char and varchar2 datatype in sql?

547

---

How many databases Microsoft SQL server provides?

610

---

Is sql server difficult to learn?

526

---

what stored procedure can you use to display the current processes? : Sql server administration

530

---

How to create a Master database in SQL server ?

551

---

What are sql server functions?

518

---

Can we update data in a view?

603

---

How to list all field names in the result set using mssql_field_name()?

528

---

How column data types are determined in a view?

534

---