for the table emp ID NAME 1 ravi 2 umang 1

how to retrieve only duplicate values in a table

Question Posted / ravi patel

9 Answers
14484 Views
I also Faced
E-Mail Answers

Answer Posted / ravi patel

for the table emp
ID NAME
1 ravi
2 umang
1 ravi
3 nishant

now fire the query as beleow

select * from emp group by id,name having count(id)>1 and
count(name)>1;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does sql between include endpoints?

972

What is forward declaration in pl sql?

1030

What are %type and %rowtype for?

1033

What is lexical units in pl sql?

1091

What is query optimization in sql?

954

What are string functions in sql?

1196

What is sql scripting?

1061

How do you concatenate in sql?

996

Is record in oracle pl sql?

921

How many triggers can be applied to a table?

1019

What is the difference between numeric and autonumber?

963

What type of database is cloud sql?

1065

What is auto increment?

959

What is difference between inner join and self join?

1054

What is dba in sql? : SQL DBA

1009