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 tablesample?

1114

How to rebuild all indexes on a single table?

1062

What is the difference between dataadapter and datareader?

1004

Do you know what is a linked server in sql server?

1025

How to get @@error and @@rowcount at the same time?

1035

What is the purpose of the master database?

1130

What is de-normalization in sql database administration? Give examples?

985

What are the benefits of filtered indexes?

1040

How can I check that whether automatic statistic update is enabled or not?

1042

What are .mdf files?

942

Do you know what are the differences between lost updates and uncommitted dependencies?

1081

What language is sql server written in?

1034

Explain about SQLOS?

1013

Explain about protocol layer present in SQL server?

1207

In which files does sql server actually store data?

906