/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 vote241 views1 answer
Add time to date sql
SQL
1 vote213 views1 answer
Oracle drop temporary table
SQL
2 votes181 views1 answer
Oracle sql query to make column data uppercase
SQL
1 vote185 views1 answer
Window function mysql
SQL
11 votes227 views1 answer
Oracle view source
SQL
5 votes147 views1 answer
Mongodb vs
SQL
4 votes181 views3 answers
Oracle sql first day of quarter
SQL
0 vote186 views1 answer
How to install sql in anaconda
SQL
3 votes237 views2 answers
How to View column names of a table in SQL
SQL
0 vote207 views1 answer
Mysql min value row
SQL