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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

How to declare and use cursor variables?

579


What is the difference between composite index and covering index?

507


How to name query output columns in ms sql server?

536


Explain what is the function of sql server agent windows service?

542


what is difference between NULL and ISNULL in SQL Server 2008?

579






How to use old values to define new values in update statements in ms sql server?

679


How do I manually uninstall an instance of sql server 2016?

544


Tell me about the approaches which you used to counter the DI problems.

755


Explain what is lock escalation and what is its purpose?

511


What are the properties of primary key?

510


What do you understand by triggers?

517


How to defragment indexes with alter index ... Reorganize?

582


What is @@error in sql?

619


Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

514


What is the difference between count () and rowcount ()?

520