4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7974 Views
- I also Faced
- E-Mail Answers
Answer Posted / murtaza
SELECT COUNT(FIELD1)AS "NO OF OCCURENCES"
FROM TABLE1
WHERE FIELD1 BETWEEN 10 AND 15
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to compare the top two records using sql?
What is microsoft sql server?
Can you create a logon trigger in sql server 2005 express edition?
What is the dbcc command and why is it used?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How to delete exactly duplicate records from a table?
How to create user defined functions with parameters?
How to skip remaining statements in a loop block using continue statements?
What is the sql server agent?
What is indexing explain it with an example?
what method you can use to reduce the overhead of Reporting Services data sources?
How to modify existing triggers using "alter trigger"?
Explain the difference between function and stored procedure?
What is the difference between dropping a database and taking a database offline?
What is normalization and its types?
