Unpivot table not showing null values
I am using an unpivot function and it displays the data. The problem is if a row is null, it does not display it's contents and I have no idea why. This is my code:
SELECT id,
CASE columnname
WHEN ‘k1’ THEN
'1'
WHEN ‘k2’ THEN
'2'
END AS
"Key",
CASE columnname
WHEN ‘V1’ THEN
'1'
WHEN 'V2' THEN
'2'
END AS
"Value"
FROM(
select id, k1,k2
from table
)
unpivot(columnresult FOR columnname IN(k1,k2)) uKeyboard shortcut to access Gnome Panel like Unity
In Unity the sortcut Alt + F10 allows to access the Unity Menu, including AppMenu and AppIndicators. Does Gnome Shell have a similar shortcut to manage the panel with the keyboard?
I am using an unpivot function and it displays the data. The problem is if a row is null, it does not display it's contents and I have no idea why. This is my code:
SELECT id,
CASE columnname
WHEN ‘k1’ THEN
'1'
WHEN ‘k2’ THEN
'2'
END AS
"Key",
CASE columnname
WHEN ‘V1’ THEN
'1'
WHEN 'V2' THEN
'2'
END AS
"Value"
FROM(
select id, k1,k2
from table
)
unpivot(columnresult FOR columnname IN(k1,k2)) uKeyboard shortcut to access Gnome Panel like Unity
In Unity the sortcut Alt + F10 allows to access the Unity Menu, including AppMenu and AppIndicators. Does Gnome Shell have a similar shortcut to manage the panel with the keyboard?
No comments:
Post a Comment