/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

11 votes221 views1 answer
Oracle view ddl
SQL
1 vote227 views1 answer
How to delete data from sql database in android
SQL
0 vote226 views2 answers
Sqlalchemy core in clause
SQL
1 vote221 views3 answers
What is union in sql
SQL
0 vote203 views1 answer
Check duplicate values plsql
SQL
0 vote226 views1 answer
Provide hardcoded value in the mysql query
SQL
1 vote229 views1 answer
Epoch time converter in snowflake
SQL
0 vote254 views2 answers
Remove mysql workbench ubuntu
SQL
0 vote212 views3 answers
Between keyword sql
SQL
7 votes210 views2 answers
N highest salary in sql
SQL