4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / vivek
Select distinct Field1 from Table1 where Field1 between 10
and 15
| Is This Answer Correct ? | 2 Yes | 17 No |
Post New Answer View All Answers
What methods do you follow to protect from sql injection attack?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to create a new table in a given schema?
Does table partitioning improve performance?
what happens on checkpoint? : Sql server database administration
What is msdb database? : SQL Server Architecture
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What are the restrictions while creating batches in sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Is sql server free?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What do you know about normalization and de- normalization?
What is sql azure database?
What are locks in sql?
How to get the definition of a trigger back?