4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 7255 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 can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How to select an exiting database using mssql_select_db()?
How to create a simple table to test triggers in ms sql server?
Write a SQL queries on Self Join and Inner Join.
Explain the categories of stored procedure?
How to create user defined functions with parameters?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
Can we update data in a view?
We need to perform what steps in the following order to work with a cursor?
How sql server enhances scalability of the database system?
Explain the xml support sql server extends?
what are the important architecture components of SSRS?
Tell me what is the significance of null value and why should we avoid permitting null values?
When do you think a developer should use sql server-based cursors?
How to recover from sql injection? : sql server security
