clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1579854 fiddles created (21380 in the last week).

CREATE TABLE pjson_table (myjson json);
 hidden batch(es)


INSERT INTO pjson_table VALUES('[ { "major" : "International business", "end" : "2007", "name" : "Annamalai University", "degree" : "Master Degree", "start" : "2005", "desc" : "" }, { "major" : "Mechanical Engineering", "end" : "1990", "name" : "Bharathidasan University", "degree" : "Bachelor Degree", "start" : "1990", "desc" : "" } ]')
1 rows affected
 hidden batch(es)


select * from pjson_table
myjson
[ { "major" : "International business", "end" : "2007", "name" : "Annamalai University", "degree" : "Master Degree", "start" : "2005", "desc" : "" }, { "major" : "Mechanical Engineering", "end" : "1990", "name" : "Bharathidasan University", "degree" : "Bachelor Degree", "start" : "1990", "desc" : "" } ]
 hidden batch(es)


SELECT x.* FROM pjson_table , json_to_recordset(myjson::json) x ( major text , "end" text , name text , degree text , start text )
major end name degree start
International business 2007 Annamalai University Master Degree 2005
Mechanical Engineering 1990 Bharathidasan University Bachelor Degree 1990
 hidden batch(es)