4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7971 Views
- I also Faced
- E-Mail Answers
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 the xml datatype?
What is identity?
How can windows applications connect to sql servers via odbc?
Define left outer join?
Can you leave a union at any time?
Which sql server table is used to hold the stored procedure scripts?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
Do you know what is bit data type and whats the information that can be stored inside a bit column?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Does sql server 2000 clustering support load balancing?
What is the use of tempdb? What values does it hold?
What is the purpose of the master database?
What is a non clustered primary key?
what is database replication? : Sql server database administration
If we delete pack Spec what will be the status of pack Body ?
