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 do we need to check in database testing?

980

How to use boolean type in select statement?

1013

What is sql data?

936

What is difference between primary and secondary key?

989

How do you select unique values in sql?

958

what is a database transaction? : Sql dba

1126

Explain what is table in a database?

1022

how to enter characters as hex numbers? : Sql dba

1004

what is a database lock ? : Sql dba

1115

How can we debug in PL/SQL?

1110

Why do we use set serveroutput on?

940

What is mutating table error?

1133

How many commands are in sql?

1018

how would you get the current date in mysql? : Sql dba

933

What is schema in sql?

898