how to find out the repeated value from table using groupby
function?
- 4 Answers
- 6472 Views
- I also Faced
- E-Mail Answers
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
You want to use a perspective in an mdx query. How do you select the perspective?
What does normalization do to data?
How to update multiple rows with one update statement in ms sql server?
What is the xml datatype?
Can multiple columns be used in sql group by clause in ms sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
What is use of except clause? How does it differ from not in clause?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What type of locking occurs during the snapshot generation? : sql server replication
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
How to get a list of columns in a view using the "sp_help" stored procedure?
What is used to replicate sessions between instances in coldfusion clusters?
what is unique and xaml nonclustered index
What are the steps to process a single select statement?
What are the source of constraints?
