GIve me record base on a If statement

1

I need help with an SQL query to give me records based on two columns in a table that

Where if Column B is 10% of Column A give me all records.

Column A -------Column B
114------------------- 96
114-------------------103
114------------------- 14
43------------------- 39
112------------------- 99

2

How to post a T-SQL question on a public forum | spaghettidba

1 Like
3

Exactly 10%?:

WHERE ColumnB = ColumnA * 0.1

At least 10%?

WHERE ColumnB >= ColumnA * 0.1

4

How about 10% and greater

5

Same as "At least 10%".