How would you Update the rows which are divisible by 10, given a set of numbers

How would you Update the rows which are divisible by 10,
given a set of numbers in column?

Question Posted / guest

3 Answers
11501 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you Update the rows which are divisible by 10, given a set of numbers in column?..

Answer / pandian s

UPDATE TableName SET Column1 = <Value>
WHERE ColumnName % 10 = 0

Is This Answer Correct ?

8 Yes

2 No

How would you Update the rows which are divisible by 10, given a set of numbers in column?..

Answer / bala

update <table> set <col> = <value> where round(<col>/10,0)
= (<col>/10)

Is This Answer Correct ?

5 Yes

0 No

How would you Update the rows which are divisible by 10, given a set of numbers in column?..

Answer / picture12345

select * from TableName where ColumnName%10=0

Is This Answer Correct ?

7 Yes

10 No

Post New Answer

More SQL Server Interview Questions

Difference between writing SQL query and stored procedure ?

15 Answers Cognizant, Infosys, TCS, Veritas,

How to use "begin ... End" statement structures in ms sql server?

0 Answers

Does union all remove duplicates?

0 Answers

What is table valued function and scalar valued functions?

0 Answers

How does a profiler work?

0 Answers

What is raid and what are different types of raid levels?

0 Answers

How to get the definition of a view out of the sql server?

0 Answers

This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?

0 Answers TCS,

Plz tell about backup&recovery?

3 Answers

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

0 Answers

Explain differentiate between a having clause and a where clause?

0 Answers

Which database stores information about replication?

0 Answers

For more SQL Server Interview Questions Click Here