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

How do I find information about the install locations for the various instances running on a computer?

1033

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953

What are the different types of locks in the database?

875

How to sort the query output with order by clauses in ms sql server?

984

what are the different types of replication you can set up in sql server? : Sql server database administration

971

What do you understand by a view?

936

How to test subquery results with the exists operator?

1036

How to convert a numeric expression from one data type to another?

934

What is sql service broker?

932

How do you rebuild an identity column?

896

How to return the top 5 rows from a select query in ms sql server?

1076

Is it possible to create trigger on views?

937

How do use Having,Group by,Group function in SQL?

1693

Explain log shipping?

961

Why use “in” clause in sql server?

997