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 is isolation levels?

1085

Do you know what is lock escalation?

1057

What is the query and subquery?

1122

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

1084

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1085

Can group by and orderby be used together?

1070

Explain what stored procedure sp_replcounters is used for? : sql server replication

1577

Â Explain what is sql override for a source taLle in a mapping?

1061

What is sql server transaction log file?

1109

what is a join and explain different types of joins? : Sql server database administration

1013

How do I connect to sql server database?

1069

What is correlated subquery in sql server?

1127

What is an inner join?

1041

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1032

What is NOT NULL Constraint in sql server 2012?

1047