4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7972 Views
- I also Faced
- E-Mail Answers
Answer Posted / anjali
select count (distinct columnname)
from tablename
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
How can we rewrite sub-queries into simple select statements or with joins?
What is the difference between a clustered index and a non-clustered index?
How can you control the amount of free space in your index pages?
Tell me what is the order in which the sql query is executed?
What is row_number function?
How do you create a clustered index?
How to get the query of a table in sql server?
Is sql server implemented as a service or an application? : Sql server database administration
Why I am getting this error when dropping a database in ms sql server?
How do you identify a foreign key?
What number sorts of privileges are accessible in sql?
How to stop log file growing too big?
Explain can SSRS reports Cache results?
