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
Does transparent data encryption provide encryption when transmitting data across the network?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
What do you understand by triggers?
How to edit table in sql server 2017?
Do you know what are the properties of the relational tables?
Is it important for a database administrator to understand the operating system and file access?
What command is used to create a database in the sql server and how?
Explain different types of index?
What is change data capture (cdc) in sql server 2008?
Is it possible to update the views? If yes, how, if not, why?
your distribution database is full what will u do
How many types of cursor type are there?
what is spatial nonclustered index
Does index slows down insert statements?
How to create sub reports?