SELECT field1 FROM table1 GROUP BY field1 HAVING COUNT(field1)>1;

4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10

Question Posted / pritesh

Answer Posted / pritesh

SELECT field1
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is dbcc updateusage?

1176

Explain what is row_number function?

1005

Mention the differences between having and where clause.

1042

What are unicode character string data types in ms sql server?

1219

Explain the difference between clustered and non-clustered index?

906

What happens to a trigger with multiple affected rows?

916

What is Federation Root Database?

104

Can sql server be linked with other servers like oracle?

945

How to find the login name linked to a given user name?

994

What is difference between primary key and foreign key?

884

What are a scheduled jobs?

943

How fixed length strings are truncated and padded?

965

Where is trigger in sql server?

1027

How to connect php with different port numbers?

1062

Explain few of the new features of sql server 2008 management studio

901