Interested to Buy Any Domain ? << Click Here >> for more details...
How would you Update the rows which are divisible by 10,
given a set of numbers in column?
- 3 Answers
- 11425 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pandian s
UPDATE TableName SET Column1 = <Value>
WHERE ColumnName % 10 = 0
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / bala
update <table> set <col> = <value> where round(<col>/10,0)
= (<col>/10)
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / picture12345
select * from TableName where ColumnName%10=0
| Is This Answer Correct ? | 7 Yes | 10 No |
How to select some specific rows from a table in ms sql server?
Explain the steps needed to create a scheduled job?
What is data source object?
How many types of schemas are there?
what is curser.
What is the difference between value type and reference type?
How can we delete a table in sql server?
What are the steps to insert a table?
how can a database be repaired? : Sql server administration
what is an index? : Sql server database administration
If we use where clause in the left outer join then how the query would behave/act?
How many types of cursor type are there?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
