4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / anjali
select count (distinct columnname)
from tablename
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
How do you create type- insensitive operator?
What is data compression? : sql server database administration
What the class forname () does?
What are the two authentication modes in sql server?
What is a functions and types in sql server?
What is the difference between a stored procedure and a user defined function?
Explain about nested stored procedure?
How do you create a data source?
Explain few examples of stored procedure over triggers?
What are parameterized reports? What are cascading parameters in ssrs reports?
What is the difference between writing data to mirrored drives versus raid5 drives
what is the maximum size of a row? : Sql server database administration
How to create new table with "create table" statements?
What is difference between global temporary tables and local temporary tables?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration