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 happens if null values are involved in string operations?

558

What is efficiency data?

520

How do triggers work?

540

What is single-user mode?

522

Which joins are sql server default?

511

what is the sql equivaent of the dataset relation object ?

1570

What is sql server used for?

556

How do I view a script in sql server?

533

What objects does the fn_my_permissions function reports on? : sql server security

559

What is use of attributehierarchyenabled? : sql server analysis services, ssas

611

What are truncate options available in sql server? : sql server database administration

583

How to use "begin ... End" statement structures in ms sql server?

524

Which tcl commands are available on the sql server?

607

What is a synonym for manipulation?

548

What is the use of sql profiler in sql server 2012?

513