If u no know the ROWID then u can delete the duplicate rows.

Is it possible to delete duplicate rows in a table without
using a temporary table ?

Question Posted / nithya

Answer Posted / nithya

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a transact-sql statement?

980

How to provide values to stored procedure parameters in ms sql server?

973

Explain the difference between function and stored procedure?

897

Explain the difference between clustered and non-clustered index?

870

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

908

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

1024

How many replicas are maintained for each SQL Azure database?

140

What is isolation levels?

961

How we can refresh the view?

1056

How to change a login name in ms sql server?

1024

What is a collation?

1036

Please explain what is “asynchronous” communication in sql server service broker?

879

How to convert a table data in XML format in sql server?

2493

What do you mean by 'normalization'?

1002

How to define and use table alias names in ms sql server?

1042