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 do mean by xml datatype?

1110

Explain about remote stored procedure?

1013

How to create a store procedure with encryption?

1010

How to connect sql server management studio express to sql server 2005 express?

1049

How many categories of data types used by sql server?

1023

How to backup SQL Server Reporting Services ?

150

Where in ms sql server is ’100’ equal to ‘0’?

1094

What command do we use to rename a database?

1082

What type of locking occurs during the snapshot generation? : sql server replication

1338

What is the template in sql?

984

Explain about service Broker functions?

1034

What is data block and how to define data block size?

1032

What are the types of indexing?

1084

what protocol both networks use? : Sql server database administration

977

Differentiate between a having clause and a where clause.

968