select count (distinct columnname) from tablename

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

Question Posted / anjali

Answer Posted / anjali

select count (distinct columnname)
from tablename

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the use of =,==,=== operators?

1014

What is the difference between lock, block and deadlock? : sql server database administration

1056

How to select some specific rows from a table in ms sql server?

1010

What is a trace frag? Where do we use it?

1104

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

946

Tell me when is the update_statistics command used?

1119

List the advantages of using stored procedures?

1061

What are the disadvantages of indexes?

1092

What are different backups available in sql server?

1080

What is dml command?

977

How to enter date and time literals in ms sql server?

1020

What is sub query and its properties?

976

What are the different types of indexes?

1121

How the authentication mode can be changed?

1137

What is analysis service repository?

1027