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 are different types of indexes?

1017

What is pragma in pl sql?

1120

List the various privileges that a user can grant to another user?

1047

explain advantages of innodb over myisam. : Sql dba

1134

What is varchar example?

1040

What are the parts of a basic sql query?

983

What is the difference between numeric and autonumber?

1008

Is join and inner join the same?

1014

Can you upgrade sql express to full sql?

1077

Mention what is the plv (pl/vision) package offers?

1110

Why do we use sql constraints?

1179

Is truncate ddl or dml?

997

Differentiate between % rowtype and type record.

1314

how to include numeric values in sql statements? : Sql dba

1110

What is the use of stored procedures?

1055