SELECT FormID, FormCode, LangCode, count(*) FROM adzForm GROUP BY Fo

how to delete duplicate rows from table

Question Posted / divya mahendra sikarwar

Answer Posted / divya mahendra sikarwar

SELECT FormID,
FormCode,
LangCode,
count(*)

FROM adzForm
GROUP BY FormID,
FormCode,
LangCode
HAVING COUNT(*)>1

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are sp_configure commands and set commands?

1015

Explain indexing and what are the advantages of it?

1016

Explain about local stored procedure?

962

Explain how dts is used to extract, transform and consolidate data?

987

What is the difference between mysql and mysqli?

1182

What are the disadvantages of indexes?

1076

What do I need to start working with sql studio? : sql server management studio

1105

Explain partitioned view?

1062

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

997

How to turn off warning messages during php execution?

1033

What is xdr?

982

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

310

How to use column default values in insert statements in ms sql server?

1022

What is report server project?

147

What are the differences between local and global temporary tables?

1071