SELECT COUNT(FIELD1)AS "NO OF OCCURENCES" FROM TABLE1 WHERE FIE

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

Question Posted / murtaza

Answer Posted / murtaza

SELECT COUNT(FIELD1)AS "NO OF OCCURENCES"
FROM TABLE1
WHERE FIELD1 BETWEEN 10 AND 15

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the commands in sql server?

1045

What are distributed partitioned views?

1086

Do you know what are the properties of the relational tables?

1034

Explain can SSRS reports Cache results?

161

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1107

How to write an inner join with the where clause in ms sql server?

1098

Define Unique Key?

1024

What is the default order of an order by clause?

1003

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

994

What is sharding?

116

what is difference between NULL and ISNULL in SQL Server 2008?

1024

What are the acid properties?

1014

What do you mean by subquery?

1095

What’s the use of custom fields in report?

949

What is difference between joins and subqueries?

1130