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

How show all rows in sql?

1011

What are the types of variables use in pl sql?

1038

What is embedded sql in db2?

1009

Sql technical questions

1269

Is left join inner or outer by default?

1014

How do you create a unique index?

1044

Can you join a table to itself?

1122

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1037

What is benefit of creating memory optimized table?

968

What is sql select statement?

1028

What are the indexing methods?

1039

what are the join types in tsql? : Transact sql

1060

Can we perform dml on view?

1040

How do I truncate a sql log file?

1065

How do I copy a table in sql?

979