4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / lalit pandey
SELECT field1,count(field1) "Number of Occurrence"
FROM table1
GROUP BY field1
HAVING COUNT(field1)>1;
Is This Answer Correct ? | 37 Yes | 0 No |
Post New Answer View All Answers
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is a natural primary key?
How to use union to merge outputs from two queries together in ms sql server?
Explain having clause and where clause?
Which are the new data types introduced in sql server 2008?
Why do you want to join software field as you have done your BE in Electronics?
How to change the ownership of a schema in ms sql server?
How to get a list all databases on the sql server?
Different types of keys in SQL?
What are sub reports and how to create them?
How to get a list of columns in a view using the "sp_columns" stored procedure?
What is Dependency Injection and provide example?
What are the different acid properties?
How to invoke a trigger on demand?
What is temporal data type?