1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Post New Answer

More SQL Server Interview Questions

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

What is right outer join in sql server joins?

0 Answers  

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

How do I make a resultset scrollable?

0 Answers  

Explain the ways to controlling cursor behavior?

0 Answers  




Is port 1433 secure?

0 Answers  

How to recompile stored procedure at run time?

0 Answers  

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

0 Answers  

Can binary strings be converted into numeric or float data types?

0 Answers  

How many categories of data types used by sql server?

0 Answers  

how to invoke a trigger on demand? : Sql server database administration

0 Answers  

What is an indexed view?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories