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
How to declare and use cursor variables?
What is the difference between composite index and covering index?
How to name query output columns in ms sql server?
Explain what is the function of sql server agent windows service?
what is difference between NULL and ISNULL in SQL Server 2008?
How to use old values to define new values in update statements in ms sql server?
How do I manually uninstall an instance of sql server 2016?
Tell me about the approaches which you used to counter the DI problems.
Explain what is lock escalation and what is its purpose?
What are the properties of primary key?
What do you understand by triggers?
How to defragment indexes with alter index ... Reorganize?
What is @@error in sql?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the difference between count () and rowcount ()?