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

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

Question Posted / pritesh

Answer Posted / pritesh

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

Is This Answer Correct ?

8 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the different types of backups available in sql server? : sql server database administration

933

Where actually sql azure database is hosted?

163

What are the advantages of using third-party tools?

1002

What do you understand by user-defined function in the sql server?

963

What are the types of database recovery models?

1132

How and why use sql server?

1021

What is the exact numeric data type in sql?

1008

Do you know how to make remote connection in database?

972

What are the aggregate and scalar functions?

1076

Write a sql query to display the current date?

1101

To which devices can a backup be created and where should these devices be located? : sql server management studio

1055

Can you explain important index characteristics?

997

How do you open a cluster administrator?

1059

How do you check sql server is up and running?

1007

What is the order in which the sql query is executed?

946