4 Please write a querry to find repeated numbers in the following table. Tab

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

Question Posted / johncy24

Answers were Sorted based on User's Feedback

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / lalit pandey

SELECT field1,count(field1) "Number of Occurrence"
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;

Is This Answer Correct ?

37 Yes

0 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / pritesh

SELECT field1
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;

Is This Answer Correct ?

8 Yes

0 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / arun kumar

SELECT Field1 FROM Table1 WHERE Field1%5=0

Is This Answer Correct ?

1 Yes

3 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / murtaza

SELECT COUNT(FIELD1)AS "NO OF OCCURENCES"
FROM TABLE1
WHERE FIELD1 BETWEEN 10 AND 15

Is This Answer Correct ?

0 Yes

2 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / anjali

select count (distinct columnname)
from tablename

Is This Answer Correct ?

1 Yes

5 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / phani

select distinct field1 from table1

Is This Answer Correct ?

0 Yes

5 No

4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 F..

Answer / vivek

Select distinct Field1 from Table1 where Field1 between 10
and 15

Is This Answer Correct ?

2 Yes

17 No