Select distinct Field1 from Table1 where Field1 between 10 and 15

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

Question Posted / vivek

Answer Posted / vivek

Select distinct Field1 from Table1 where Field1 between 10
and 15

Is This Answer Correct ?

2 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What methods do you follow to protect from sql injection attack?

967

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

937

How to create a new table in a given schema?

1112

Does table partitioning improve performance?

902

what happens on checkpoint? : Sql server database administration

1018

What is msdb database? : SQL Server Architecture

1060

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

837

What are the restrictions while creating batches in sql server?

1004

What is perspective, have you ever created perspective? : sql server analysis services, ssas

859

Is sql server free?

870

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

850

What do you know about normalization and de- normalization?

870

What is sql azure database?

205

What are locks in sql?

931

How to get the definition of a trigger back?

958