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

Can two tables share a primary key?

1004

What is BCNF? How is it better than 2NF & 3NF?

998

How will you optimize a stored procedure optimization?

1014

How do I completely remove sql server instance?

1077

What is sql or structured query language?

1130

What is a ddl statement?

892

How many non clustered indexes there can be on table ?

895

Which are the third-party tools used in sql server and why would you use them?

878

Write a query to find 5th highest amount paid from the customer table.

921

what is the system function to get current user's user id? : Sql server database administration

981

Why truncate is ddl command?

1043

Why variables called the most powerful component of ssis?

1058

What is snapshot parameter in ssrs?

150

Explain sql server authentication modes?

1111

What is wide table?

934