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?

The Role of 3D Printing in Business: Revolutionizing Industries
Business

The Role of 3D Printing in Business: Revolutionizing Industries

3D printing in business has become a transformative technology, offering innovative solutions across various industries. From manufacturing and product design to supply chain management and prototyping, 3D printing has introduced new ways for businesses to operate, improve efficiency, and enhance creativity. In this article, we will explore how 3D printing is being integrated into business […]

Read More
AI-Powered Business Solutions: Transforming the Future of Business Operations
Business

AI-Powered Business Solutions: Transforming the Future of Business Operations

In today’s rapidly evolving business landscape, the integration of artificial intelligence (AI) is no longer just a luxury but a necessity for staying competitive. AI-powered business solutions are revolutionizing how companies operate, make decisions, and interact with customers. These solutions are enabling businesses to streamline operations, enhance customer experiences, and drive innovation across various industries. […]

Read More
Crafting Perfection: The Artistry Behind Exquisite Diamonds
Business

Crafting Perfection: The Artistry Behind Exquisite Diamonds

In the realm of precious gems, one stone stands above the rest in brilliance, elegance, and timeless allure: the diamond. Renowned for its unparalleled beauty and enduring symbolism, diamonds have captivated hearts and minds for centuries, earning their place as the undisputed number one choice for discerning connoisseurs and sentimental souls alike. The Enduring Allure […]

Read More