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
What is outer join in sql server joins?
What are the requirements for sql server 2016?
Explain what is the difference between union and union all?
What are the purposes of floor and sign functions?
What are the reporting services components?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How to generate random numbers with the rand() function in ms sql server?
Explain “not null constraint” in sql server?
How many servers can we create in a single subscription?
Benefits of Stored Procedures?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Explain the types of indexes.
What is dirty page?
What is the downside of using udf?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?