How to use case in a where clause – SQL Server [closed]

I have a query that looks like this:

SELECT col1,col2
FROM dbo.table1

Now I am requested to filter out using a case clause:

if col1 > 5 then display only col2 > 10
and if col1 <= 5 then display only col2 > 20

Is there a way to do that?

How To Choose The Right Chair For Your Needs?
Business

How To Choose The Right Chair For Your Needs?

If you work in an office, then you know how important it is to have a chair that will not only provide support for the back and the spine but at the same time will be comfortable and accommodating to your needs. It can make all the difference in how well you do your job […]

Read More
Do You Make These Simple Mistakes In WordPress Gallery Plugin?
Business

Do You Make These Simple Mistakes In WordPress Gallery Plugin?

If you’re using WordPress to manage your website, then you’re probably using a plugin to create galleries of images. But are you making simple mistakes that could cost you traffic and jeopardize your SEO? Here are four common mistakes people make with their WordPress gallery plugins: Not Optimizing Image File Names When you upload an […]

Read More
The Benefits Of Kucoin Cryptocurrency Exchange
Business

The Benefits Of Kucoin Cryptocurrency Exchange

With over 700+ cryptocurrencies to choose from, KuCoin cryptocurrency exchange is always at the forefront of the crypto space. You can trade Bitcoin, ethereum, and over 700 other coins with KuCoin cryptocurrency exchange. You can even trade Luna Crypto at KuCoin cryptocurrency exchange. In this article, we’ll go over the benefits of KuCoin cryptocurrency exchange […]

Read More