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

What is rolap and its advantage? : sql server analysis services, ssas

1283

What is temporary table in sql server? Why we use temp table?

953

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1943

Explain about Normalization?

1069

What’s the distinction between dropping a info and taking a info offline?

1038

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

942

What is tablix?

162

What is user defined stored procedures?

946

How are the unique and primary key constraints different?

1075

What is raid? : SQL Server Architecture

1180

What is the difference between DataRow.Delete() and DataRow.Remove()?

1230

What is a dbms wizard?

1020

Can you please differentiate between a primary key and a unique key?

1009

How can we use ConnectorJ JDBC Driver with MS SQL?

1000

What are the operating modes in which database mirroring runs?

1089