SELECT Field1 FROM Table1 WHERE Field1%5=0

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

Question Posted / arun kumar

Answer Posted / arun kumar

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is explicit mode in sql server?

1044

What is the difference between a unique key and primary key?

932

Explain about sql server login?

1067

When do you think a developer should use sql server-based cursors?

1023

Which sql server table is used to hold the stored procedure script?

932

How will you make an attribute not process? : sql server analysis services, ssas

1067

How to list all stored procedures in the current database using ms sql server?

1112

What are logical database components? : SQL Server Architecture

1017

What is meant by dirty read?

980

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

963

Which are the two editions in which SQL Azure database available?

119

What does ss stand for sexually?

1068

difference between Clustered index and non clustered index ?

978

How can sql server instances be hidden? : sql server security

1122

What is a transaction and why is it important?

1071