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

why would you use sql agent? : Sql server database administration

1270

What type of locking occurs during the snapshot generation? : sql server replication

1377

What is the difference between ddl and dml?

1101

What is the sql profiler?

1001

What is difference between joins and subqueries?

1173

Do you know what are the ways available in sql server to execute sql statements?

1082

Why do we use trigger?

1029

When would you use the stored procedures or functions?

1054

What is TDS(Tabular Data Stream) Gateway?

127

Explain the properties of a relational table?

1079

What is coalesce and check constraint in sql server?

1179

How and why use sql server?

1063

What is updatable resultset?

1075

Can you create a logon trigger in sql server 2005 express edition?

1125

Tell me the phases a transaction has to undergo?

1019