Question of the Day
I have some data in a table that looks like this:
BeerID BeerName brewer beerdescription
1 Becks Interbrew Beck's is a German-style pilsner beer
2 Fat Tire New Belgium Toasty malt, gentle sweetness, flash of fresh hop bitterness.
3 Mac n Jacks Mac & Jack's Brewery This beer erupts with a floral, hoppy taste
4 Alaskan Amber Alaskan Brewing Alaskan Brewing Amber Ale is an "alt" style beer
8 Kirin Kirin Brewing Kirin Ichiban is a Lager-type beer
If I run this, what is returned?
select t1.key
from openjson((select t.* FROM Beer AS t for json path)) t1 See possible answers