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

7 Answers
9136 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Why are views required in the sql server or in any other database?

965

What is de-normalization in sql database administration? Give examples?

985

How to change the ownership of a schema in ms sql server?

1195

How to attach adventureworkslt physical files to the server?

1106

What is the fillfactor concept in indexes?

987

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

1049

What is difference between global temporary tables and local temporary tables?

1238

How do clustered indexes store data?

1107

What is the command used to check locks in microsoft sql server?

1044

what's sql server? : Sql server database administration

1000

How to create a scrollable cursor with the scroll option?

999

what are cursors? : Sql server database administration

1062

What is model database in sql server?

1054

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

1010

How to create user defined functions with parameters?

1236