/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 vote388 views1 answer
Having all mysql
SQL
1 vote360 views1 answer
Add multiple row table pl sql
SQL
0 vote403 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
3 votes331 views1 answer
Convert sqlite table to pandas dataframe
SQL
2 votes369 views2 answers
Postgresql search all tables for column name
SQL
0 vote367 views1 answer
Sql change column in existing table
SQL
0 vote325 views1 answer
Mysql create table like
SQL
4 votes354 views1 answer
T-sql get duplicate rows
SQL
10 votes345 views1 answer
Query to find object dependencies in oracle
SQL
0 vote335 views1 answer
Oracle sql winter time change
SQL