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
What's the information that can be stored inside a bit column?
What is the security principal at the database level that represents your session?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What is the synonym of join?
How to optimize stored procedure optimization?
what's the difference between a primary key and a unique key? : Sql server database administration
What is transaction server distributed transaction?
How many joins in sql server?
What is the difference between implicit and explicit transaction?
Why can there be only one clustered index and not more than one?
How will you go about resolving deadlocks?
How to write character string constants or literals in ms sql server?
Explain boyce and codd normal form(bcnf)?
what is a default tcp/ip socket assigned for sql server? : Sql server database administration
Explain partitioned view?