Sign Up Login


  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

How does index makes search faster?

0 Answers   QuestPond,

Explain few examples of RDBMS?

0 Answers   Wipro,

What are pessimistic lock and optimistic lock?

0 Answers  

What are the purpose of Normalisation?

0 Answers   HCL,

How to truncate a table first before running a package?

1 Answers  




What is the difference between constraints and triggers?

9 Answers   Wipro,

Write an SQL query to obtain the 2nd highest salary.

0 Answers   Akamai Technologies,

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

What is the template in sql?

0 Answers  

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee

3 Answers   NIIT,

What are the different types of joins and what does each do?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories