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
- 9038 Views
- I also Faced
- E-Mail Answers
Answer Posted / phani
select distinct field1 from table1
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Explain syntax for disabling triggers?
What is the sql case statement used for? Explain with an example?
What is ddl and dml commands?
What is instead of dml trigger?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
What are the differences between substr and charindex in sql server.
What are the database roles? : sql server security
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is tempdb in sql server?
What is the difference between functions and stored procedures?
How do I perform an unattended install of sql server 2000?
How to provide default values to function parameters?
What are the built in functions in sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What is equi join with example?
