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

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

Question Posted / guest

Answers were Sorted based on User's Feedback

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

Answer / arshi

SELECT COUNT(CoumnName) AS Expr1
FROM Tablename
GROUP BY CoumnName
HAVING (COUNT(CoumnName) > 1)

Is This Answer Correct ?

8 Yes

0 No

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

Answer / karthik

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

Is This Answer Correct ?

1 Yes

0 No

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

Answer / vishu

by using count(colun name ) and differd calumn

Is This Answer Correct ?

0 Yes

1 No

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

Answer / navin.cp

SELECT COUNT(Column_Name) FROM Table_Name WHERE (Condition)
GROUP BY Column_Name

Is This Answer Correct ?

0 Yes

3 No