select eno,count(1) cnt from emp group by eno having count(1)

how to find out the repeated value from table using groupby
function?

Question Posted / karthik

Answer Posted / karthik

select eno,count(1) cnt from emp
group by eno having count(1) > 1;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the difference between “where” and “having” clause in sql server?

1075

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1141

Explain the collation?

1115

How and why use sql server?

1014

difference between Clustered index and non clustered index ?

996

When we should use @@error?

975

How connect excel to sql server?

1000

Do you know what are the differences between lost updates and uncommitted dependencies?

1084

What is sql server programming?

1046

What is side by side migration in sql server?

1110

What is replication and database mirroring?

1051

What is importing utility?

990

How to list all dsn entries on your local machine using odbc_data_source()?

1040

Explain try...catch with sql server?

1025

What is sparse columns of sql server 2008?

1058