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
how many triggers you can have on a table? : Sql server database administration
What is model database in sql server?
How to create new table with "create table" statements?
What are different backups available in sql server?
Explain why variables called the most powerful component of ssis?
How to return the top 5 rows from a select query in ms sql server?
Characterize join and name diverse sorts of joins?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the query and subquery?
Explain trigger classes i.e. Instead of and after trigger?
What is the difference between ddl and dml?
How do you size a resultset?
What are sql dirty pages?
What are views used for?
Can sql servers link to other servers like oracle?