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

What are different types of collation sensitivity?

540

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

577

What is RMS migrations?

1698

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1573

What are the different ways you can create databases in sql server?

567

What is the maximum size of a dimension? : sql server analysis services, ssas

555

What security features are available for stored procedure?

587

what protocol both networks use? : Sql server database administration

534

Would you store your query in a ssrs report or a database server? State the reason why?

108

What is store procedure? When do you use?

521

What is the server name for sql management studio?

473

Explain magic tables in sql server?

545

Is ssrs support other database except ms sql server?

What is the index requirement in SQL Azure?

What is save transaction and save point?

622