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

Write a sql query to get zero records from a table having n number of records?

1129

How does index makes search faster?

919

What is built-in/administrator?

956

How to create percentile function?

139

what is hash nonclustered index

907

Explain hostprotectionattribute in sql server 2005?

960

What is a domain constraint give an example?

1003

Explain for xml explicit mode?

912

How to find the login name linked to a given user name?

942

What is xdr?

929

How to list all user defined functions in the current database?

975

Does partitioning improve performance?

917

How do you create an execution plan?

885

What are sub reports?

186

When would you use the stored procedures or functions?

947