/SQL/Create view in sql server that contain multiple select statements

Create view in sql server that contain multiple select statements

SELECT     X AS 'First', Null as 'Second'
FROM       The_Table
WHERE     The_Value = 'y'
Union
SELECT     null as 'First', X AS 'Second'
FROM       The_Table
WHERE     The_Value = 'z'

Source: stackoverflow.com

Similar codes

-1 vote201 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
0 vote203 views1 answer
Oracle job class
SQL
0 vote195 views1 answer
How to search query in python3 sqlite3
SQL
0 vote235 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote270 views1 answer
Fetching data from mysqldb
SQL
3 votes217 views2 answers
Df to sql pandas sql achemy
SQL
1 vote189 views1 answer
How to use a trigger to validate input data
SQL
11 votes188 views2 answers
Having clause
SQL
0 vote197 views2 answers
How to combine diff colmun value using group by postgres
SQL
6 votes254 views2 answers
Subtr Oracle ?
SQL