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

Answer Posted / arun kumar

SELECT Field1 FROM Table1 WHERE Field1%5=0

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many triggers you can have on a table? : Sql server database administration

702


What is model database in sql server?

775


How to create new table with "create table" statements?

726


What are different backups available in sql server?

756


Explain why variables called the most powerful component of ssis?

702






How to return the top 5 rows from a select query in ms sql server?

778


Characterize join and name diverse sorts of joins?

678


What is the syntax to execute the sys.dm_db_missing_index_details?

741


What is the query and subquery?

802


Explain trigger classes i.e. Instead of and after trigger?

639


What is the difference between ddl and dml?

774


How do you size a resultset?

676


What are sql dirty pages?

756


What are views used for?

778


Can sql servers link to other servers like oracle?

601