/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 vote148 views1 answer
Backup mysql schema only
SQL
0 vote106 views1 answer
IIF
SQL
0 vote119 views2 answers
Sql join on wildcard
SQL
0 vote118 views1 answer
Mysql pv progres
SQL
1 vote137 views1 answer
UseSqlServer no definition
SQL
-1 vote124 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote132 views1 answer
Nodejs sql get one to many relationship as array
SQL
1 vote109 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
15 votes120 views3 answers
Postgresql change column type
SQL
0 vote116 views1 answer
How to write if case in select query in select statement
SQL