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
Explain what is meant by replication of database?
Can one drop a column from a table?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Can you explain the disadvantages/limitation of the cursor?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
Explain something about security and SQL Azure?
Mention the different types of triggers?
what is normalization? : Sql server database administration
Can we store videos inside the sql server table?
How to find related tables in sql server?
Write SQL queries on Self Join and Inner Join.
How to list all objects in a given schema?
What is the use of for clause?
What is clustered vs nonclustered index?
What is the use of set nocount on/off statement?