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 is advantage data architect?
How to convert a unicode strings to non-unicode strings?
What are the options which must be set to allow the usage of optimistic models?
What is policy based management (pbm)? : sql server database administration
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is cte (common table expression)?
What is the process of normalization?
Explain what is the purpose of sql profiler in sql server?
what is the difference between openrowset and openquery?
What is the maximum size of a row in sql server?
Are semicolons required at the end of sql statements in sql server 2005?
How to create a simple table to test triggers in ms sql server?
What are out-of-range errors with date and time literals?
What is CTE in SQL
Does group by sort data?