User:SwMATHimport240215: Difference between revisions
From MaRDI portal
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
quick statements generatino SQL command | quick statements generatino SQL command | ||
< | <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" | ||
from swmath_software | from swmath_software | ||
where id not in (Select swid from zz_mors_mardi_software) | where id not in (Select swid from zz_mors_mardi_software) | ||
</ | </syntaxhighlight> | ||
Example data | |||
<syntaxhighlight lang=csv> | |||
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 | |||
</syntaxhighlight> | |||
Revision as of 17:08, 15 February 2024
quick statements generatino 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