User:SwMATHimport240215: Difference between revisions
From MaRDI portal
No edit summary |
typo fix |
||
| Line 1: | Line 1: | ||
quick statements | quick statements generation SQL command | ||
<syntaxhighlight lang=sql> | <syntaxhighlight lang=sql> | ||
SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len" | SELECT '' as "qid", '"' || cast(id as text) || '"' as "P13", name as "Len" | ||
Revision as of 23:46, 18 February 2024
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