Skip to content

Instantly share code, notes, and snippets.

@Phil-Factor
Created March 5, 2019 13:29
JSON Result that emerged From SQL Query
[
{
"title":"The Busy Executive's Database Guide",
"type":"business ",
"price":19.9900,
"advance":5000.0000,
"royalty":10,
"ytd_sales":4095,
"notes":"An overview of available database systems with emphasis on common business applications. Illustrated.",
"pubdate":"1991-06-12T00:00:00",
"Authors":[
{
"au_fname":"Marjorie",
"au_lname":"Green",
"phone":"415 986-7020",
"address":"309 63rd St. #411",
"city":"Oakland",
"state":"CA",
"zip":"94618",
"contract":true,
"au_ord":2,
"royaltyper":40
},
{
"au_fname":"Abraham",
"au_lname":"Bennet",
"phone":"415 658-9932",
"address":"6223 Bateman St.",
"city":"Berkeley",
"state":"CA",
"zip":"94705",
"contract":true,
"au_ord":1,
"royaltyper":60
}
],
"publisher":[
{
"pub_name":"Algodata Infosystems",
"city":"Berkeley",
"state":"CA",
"country":"USA"
}
],
"RoyaltyShedule":[
{
"lorange":0,
"hirange":5000,
"royalty":10
},
{
"lorange":5001,
"hirange":50000,
"royalty":12
}
],
"Sales":[
{
"stor_name":"Eric the Read Books",
"stor_address":"788 Catamaugus Ave.",
"city":"Seattle",
"state":"WA",
"ord_num":"6871",
"ord_date":"1994-09-14T00:00:00",
"qty":5,
"payterms":"Net 60",
"title_id":"BU1032"
},
{
"stor_name":"Bookbeat",
"stor_address":"679 Carson St.",
"city":"Portland",
"state":"OR",
"ord_num":"423LL930",
"ord_date":"1994-09-14T00:00:00",
"qty":10,
"payterms":"ON invoice",
"title_id":"BU1032"
}
]
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment