SELECT field1,count(field1) "Number of Occurrence" FROM table1

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

Question Posted / lalit pandey

Answer Posted / lalit pandey

SELECT field1,count(field1) "Number of Occurrence"
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;

Is This Answer Correct ?

37 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you Implement SSIS Packages in your Project?

1905

What is xml datatype?

1062

Who is the owner of a schema in ms sql server?

1058

Explain what are the restrictions while creating batches in sql server?

1044

What are constraints in microsoft sql server?

1097

How can I track the changes or identify the latest insert-update-delete from a table?

937

What are the steps to follow to configure SQL*Net?

1018

How the authentication mode can be changed?

1111

Does a specific recovery model need to be used for a replicated database? : sql server replication

942

How to check if stored procedure is running in sql server?

1025

Can we write a distributed query and get some data which is located on other server and oracle database?

1205

What is a join in sql?

1067

What is the difference between Triggers and Stored Procedure?

1078

What's new in sql management studio for sql server? : sql server management studio

1051

List out a number of the wants to setup a SQL Server failover cluster?

1044