User:SwMATHimport240215

From MaRDI portal
Revision as of 23:46, 18 February 2024 by Daniel (talk | contribs) (typo fix)

quick statements generation SQL command

SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len"
from swmath_software
where id not in (Select swid from zz_mors_mardi_software)

Example data

qid,P13,Len
"","""45040""",Disco
"","""41172""",CANS+
"","""41159""",SPECTOR3D
"","""42240""",VecDualSPHysics
"","""46232""",GPT-4
"","""45587""",groupICA
"","""44347""",SymSpin
"","""46610""",HYSPLIT
"","""41774""",GENE-3D
"","""42090""",FeatureScout
"","""46144""",PARETO
"","""45275""",ScaFi
"","""46052""",SearchCol
"","""44452""",CALIMA
"","""46722""",Juno
"","""45475""",PairDiagSph