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 secondary xml indexes?

782

How to identify current user in ssrs report?

326

How to modify existing triggers using "alter trigger"?

698

Can we hide the definition of a stored procedure from a use?

865

What is attribute hierarchy? : sql server analysis services, ssas

708

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2261

List all types of constraints in sql server?

679

How do I find the default sql server instance?

695

What are the types of dml?

732

what is spatial nonclustered index

718

What are the types of resultset?

708

what is a correlated sub-query? : Sql server database administration

672

Does group by sort data?

672

Can we perform backup restore operation on tempdb?

740

Why can there be only one clustered index and not more than one?

730