/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

17 votes333 views2 answers
Mysql date to string
SQL
2 votes323 views1 answer
Date conversion in mysql column
SQL
1 vote319 views1 answer
Last 6 months postgresql
SQL
0 vote315 views1 answer
Oracle sql winter time change
SQL
0 vote322 views2 answers
Mysql select date from datetime
SQL
0 vote353 views2 answers
Sql having multiple conditions
SQL
1 vote381 views1 answer
How not to sort by average rating
SQL
3 votes327 views1 answer
Oracle list invalid password ORA-01017
SQL
1 vote323 views1 answer
How to open closed port mysql in ubuntu
SQL
5 votes324 views2 answers
Get columns number sql
SQL