/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

8 votes123 views3 answers
Mysql alter table add index
SQL
0 vote165 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
5 votes140 views2 answers
To date oracle
SQL
0 vote123 views1 answer
Mysql record group by created date count
SQL
0 vote125 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote151 views1 answer
Repeatable read trong sql server
SQL
0 vote127 views1 answer
Grepper sql workbench download
SQL
3 votes127 views4 answers
Truncate syntax in sql
SQL
0 vote139 views1 answer
Mysql workbench primary key
SQL
2 votes134 views1 answer
Date conversion in mysql column
SQL