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

List the different types of collation sensitivities in sql server?

972

Explain transaction server explicit transaction?

876

Define inner join in sql server joins?

986

What does REVERT do in SQL Server 2005?

913

How can I tell if sql server is 32 or 64 bit?

901

What is tablesample?

1026

What is an sql server agent?

994

Do you know what is sql service broker?

994

What is acid mean in sql server?

1035

What is the difference between rank and dense_rank?

990

do you know how to configure db2 side of the application? : Sql server database administration

985

What is difference between sql and sql server?

936

what is an index? : Sql server database administration

930

How can you append an identity column to a temporary table?

874

What is policy management?

932