Interested to Buy Any Domain ? << Click Here >> for more details...
4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
- 7 Answers
- 8835 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
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the difference between seek predicate and predicate?
How to create new databases with "create database" statements?
How to enforce security in sql server? : sql server security
Explain isolation levels that sql server supports?
How do you troubleshoot errors in a SQL Server Agent Job?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How do I start sql server 2017?
How to insert stored procedure result into temporary table?
What are the types of dml?
Tell me the use of keyword with encryption. Create a store procedure with encryption?
Can you explain what is sql server english query?
Explain transaction server explicit transaction?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Explain linked server in sql?
