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

Explain what is meant by replication of database?

1031

Can one drop a column from a table?

1020

You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?

155

Can you explain the disadvantages/limitation of the cursor?

987

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2362

Explain something about security and SQL Azure?

134

Mention the different types of triggers?

1114

what is normalization? : Sql server database administration

1095

Can we store videos inside the sql server table?

979

How to find related tables in sql server?

943

Write SQL queries on Self Join and Inner Join.

1154

How to list all objects in a given schema?

1057

What is the use of for clause?

1118

What is clustered vs nonclustered index?

946

What is the use of set nocount on/off statement?

1097