/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 vote277 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
-2 votes297 views1 answer
No module named '_sqlite3
SQL
11 votes289 views2 answers
Turn off safe mode mysql
SQL
21 votes295 views6 answers
Change column in mysql
SQL
0 vote296 views1 answer
WHERE not regex in SQL
SQL
0 vote279 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote323 views1 answer
Find size of all DB's postgres
SQL
2 votes290 views1 answer
How to create sql database
SQL
0 vote291 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote279 views1 answer
Kotlin sqlite delete row
SQL