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 is the basic form of sql query?

879

What is time based sql injection?

900

How are sql commands classified?

1031

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3515

Where not exists in sql?

904

What is memory optimized table?

984

What are sql functions? Describe the different types of sql functions?

1054

When do we use triggers?

1025

How can get second highest salary in sql?

907

What is triggering circuit?

1011

What is difference between hql and sql?

988

Can we update views in sql?

896

Is primary key always clustered index?

944

Is sql sequential or random?

980

What are all the different types of indexes?

1090