select distinct field1 from table1

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

Question Posted / phani

Answer Posted / phani

Is This Answer Correct ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is the difference between SQL notification and SQL invalidation?

1267

How to concatenate two character strings together?

1170

What is always encrypted?

1057

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1269

What are the requirements to use odbc connections in php scripts?

1159

What are the five characteristics of good data?

974

What is log in sql server?

1205

Do you know what is difference between stored procedure and user defined function?

1156

What is 'write-ahead log' in sql server 2000 ?

1108

Can You Use Data Mining Models In Ssrs?

152

What is difference between index seek vs. Index scan?

1202

What are the different types of Indexes available in SQL Server?

1060

How to make conditional sum in ssrs?

183

How to replace the Query Result 'Null Value' with a text ?

1098

Mention the differences between having and where clause.

1120