Use Group clause and having count

what eliminate duplicate without using roenum and not

Question Posted / sathish

Answer Posted / sathish

Use Group clause and having count < 2

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What does select top 1 do in sql?

1097

What is the sql*loader? : aql loader

1052

What is the difference between sql, mysql and sql server?

1105

What is composite primary key in sql?

996

What is a database event trigger?

1159

Explain locks? : Transact sql

1010

Is it possible to sort a column using a column alias?

1048

Why is pl sql needed?

946

What are the two types of cursors in pl sql?

1082

What is a join query?

964

State few characteristics of pl/sql?

971

How do you write a complex sql query?

1082

What does the sign mean in sql?

989

what is sql server agent? : Sql dba

1109

What is recursive stored procedure?

1099