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

Can you explain what is indexed view? How to create it?

885

Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?

979

What are commonly used odbc functions in php?

1000

when you create a database how is it stored? : Sql server database administration

996

Please explain go command in sql server?

1026

What are null values in ms sql server?

1060

How to delete a login name in ms sql server?

1046

1 01 101 01010

2035

What Is Rdbms?

1131

Does a full backup include transaction log?

948

How can I know what locks are running on which resource?

937

What does it mean to normalize a database and why would you do it?

966

How do I start sql server 2017?

919

How can you list all the columns in a database?

912

How you can find out if an index is useful to the optimizer?

921