4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / phani
select distinct field1 from table1
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How we can compare two database data?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
Disadvantages of the indexes?
What is resource governor?
Explain subquery and state its properties?
What are the filtered indexes?
What is 2nf example?
What are the different types of upgrades that can be performed in sql server?
Is INSTEAD OF trigger directly applicable to Table ?
List the different index configurations possible for a table?
How to convert a unicode strings to non-unicode strings?
What is the name of reporting services config file and what’s it’s used for?
What is difference between after and before?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to create database with physical files specified in ms sql server?