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 are the advantages of sql stored procedure?

1124

How is foreign key related to primary key?

1014

Define msdb database?

1078

What is the use of toad or sqldbx.?

1204

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

How will you find out if there are expensive SQL statements running or not?

1072

If any stored procedure is encrypted, then can we see its definition in activity monitor?

1044

What is the partitioning method?

1068

Explain isolation levels that sql server supports?

1085

What are the different types of indexes?

1161

How to get @@error and @@rowcount at the same time?

1084

What is a cube? : sql server analysis services, ssas

1055

What is bookmark link in ssrs?

251

Explain what is public role in sql server?

1193

Explain acid?

1146