4 Please write a querry to find repeated numbers in the
following table.
Table Name: Table1
Field1
10
15
20
15
10
Answer Posted / arun kumar
SELECT Field1 FROM Table1 WHERE Field1%5=0
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where are SQL server users names and passwords are stored in sql server?
What will be query used to get the list of triggers in a database?
Do you have any idea about the tcl commands?
What is single-user mode?
How to select an exiting database using mssql_select_db()?
How to change parameter value inside the report?
What are the types of sql server?
What are out-of-range errors with date and time literals?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How do you identify a foreign key?
Is resultset an interface?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Can I work with several databases simultaneously? : sql server management studio
last function used in MS Access to convert sql what function will use in sql
What command would you use to create an index?