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

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

522

What are the different editions available in sql server 2000?

587

Is sql server free?

523

What is a trace frag?

641

How many replicas are maintained for each SQL Azure database?

128

What are sparse columns?

585

How to count rows with the count(*) function in ms sql server?

538

What are relationships and mention different types of relationships in the dbms

557

What is the significance of null value and why should we avoid permitting null values?

531

Explain what stored procedure sp_replcounters is used for? : sql server replication

1001

what is spatial nonclustered index

542

Explain a join?

615

What is raid, and how it can influence database performance?

576

What is the difference between left and right outer join?

545

What the difference between UNION and UNIONALL?

573