Case for select - SQL

Question

Hi, is it possible to fire different select statements using case check in sql.
Something like E.g.: Case when 1 = N then select a from tab1 else select b from tab1.

Please let me know if it’s possible using sql not any pl sql block.

-MS

Answer 1

You can nest subqueries.

General overview:

https://community.modeanalytics.com/sql/tutorial/sql-subqueries/

More nuanced:

https://blogs.msdn.microsoft.com/craigfr/2006/08/23/subqueries-in-case-expressions/