/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 vote111 views1 answer
Oracle duration between timestamps
SQL
0 vote60 views1 answer
Oracle list all stored procedures
SQL
0 vote115 views1 answer
Delete a record from a table sqlite3
SQL
0 vote108 views1 answer
Codeigniter dbforge add index
SQL
1 vote124 views2 answers
How to combine 2 tables in MySQL
SQL
5 votes102 views2 answers
Oracle timestamp to date
SQL
2 votes135 views2 answers
Install postgresql
SQL
6 votes98 views3 answers
Mysql server is not starting xampp
SQL
0 vote112 views1 answer
How to check xampp mysql password
SQL
0 vote107 views1 answer
SQL column name Oracle
SQL