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 is an active database?

1072

Explain syntax for dropping triggers?

969

How you can minimize the deadlock situation?

1084

How to rebuild the master database?

1138

What is shared lock?

949

optimization techinques

2721

Explain what is log shipping?

1196

Is the order of columns in the set clause important in ms sql server?

1014

What does COMMIT command do?

1122

How to drop an existing table with "drop table" statements in ms sql server?

1149

What is difference between rownum and rowid?

958

What are the types of indexes?

1133

What is the stored procedure?

1054

between cast and convert which function would you prefer and why?

1020

What is xml datatype?

1131