/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

0 vote145 views1 answer
Drop index in sql
SQL
10 votes141 views5 answers
Between keyword in sql
SQL
0 vote100 views1 answer
Online sql compiler
SQL
4 votes146 views1 answer
Refresh postgres config
SQL
0 vote142 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote161 views1 answer
Postgressql uuid
SQL
24 votes137 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote126 views1 answer
Mysql regex exact match
SQL
0 vote149 views1 answer
Oracle sql number to varchar2
SQL
1 vote143 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL