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

Can a synonym name of a table be used instead of a table name in a select statement?

1010

Why normalization is used?

993

What is the difference between varchar and varchar types?

1058

Do you know what is replace and stuff function in sql server?

992

What is temporary stored procedure?

924

How to convert numeric values to integers in ms sql server?

1063

What is a constant or literal in ms sql server?

1026

What are user-defined functions (udfs) in sql server?

971

What is SQL Azure Firewall?

136

How network traffic be reduced by using the stored procedure?

1089

What is function of ROLLUP ?

1069

What is meant by Active-Passive and Active-Active clustering setup?

1144

What is a trigger in sql server?

1143

Write a program to fetch first 10 records from a file?

988

What are the different sql server versions?

962