How to count the number of duplicate items in a table?
- 3 Answers
- 7954 Views
- I also Faced
- E-Mail Answers
Answer Posted / pavan
Hi,
try this query.In this query sal one val is duplicated
4items
select sal,count(sal) from test group by sal having count
(*)>1
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is exclusive locks?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Does sql server use t sql?
What is the process of indexing?
How to set database to be single_user in ms sql server?
What is the distinction amongst delete and truncate?
Give an example of SQL injection attack ?
Explain different types of collation sensitivity?
What is database white box testing?
Write a sql query to sort on different column name according to the parameters passed in the function?
What is the xml datatype?
What are dml triggers and types of dml triggers?
Explain the working of sql privileges?
How many replicas are maintained for each SQL Azure database?
What do you mean by an execution plan?
