How would you Update the rows which are divisible by 10,
given a set of numbers in column?
Answer Posted / picture12345
select * from TableName where ColumnName%10=0
| Is This Answer Correct ? | 7 Yes | 10 No |
Post New Answer View All Answers
What is a group function explain with an example?
What will be the maximum number of indexes per table?
How to generate create view script on an existing view?
Is it true that rules do not apply to data already existing in a database at the time the rule is created?
What are the events recorded in a transaction log?
What is xdr?
How do you create a data source?
what is a check constraint?
What is the purpose of indexing?
What is standby servers? Explain types of standby servers.
Can two different columns be merged into single column? Show practically?
How to convert a numeric expression from one data type to another?
Can sql servers linked to other servers like oracle?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is the usage of the sign function?