Anzeige
Archiv - Navigation
1900to1904
Aktuelles Verzeichnis
Verzeichnis Index
Übersicht Verzeichnisse
Vorheriger Thread
Rückwärts Blättern
Nächster Thread
Vorwärts blättern
Anzeige
HERBERS
Excel-Forum (Archiv)
20+ Jahre Excel-Kompetenz: Von Anwendern, für Anwender
Inhaltsverzeichnis

create table in excel using sql

create table in excel using sql
23.09.2022 13:30:03
billy21
In my Excel inquiry, I have a SQL command to create a table. I'm not sure whether this is feasible I'm following this article https://www.scaler.com/topics/sql/create-table-in-sql/, but can you combine two instructions into a single query?
I have:

SELECT TALLY_TRAN_MSTR.LOGON_ID, SUM(TALLY_TRAN_MSTR.FULL_PLLT_QTY), TALLY_TRAN_MSTR.SHIFT_DT
FROM WBR_RW.TALLY_TRAN_MSTR
GROUP BY TALLY_TRAN_MSTR.LOGON_ID, TALLY_TRAN_MSTR.SHIFT_DT
and

SELECT TALLY_TRAN_MSTR.PRI_GRP_CD
WHERE (TALLY_TRAN_MSTR.PRI_GRP_CD = "PUT")
I was able to get this code to operate independently, but I'm not sure how to integrate them. Is there a way to accomplish this?

2
Beiträge zum Forumthread
Beiträge zu diesem Forumthread

Betreff
Datum
Anwender
Anzeige
AW: create table in excel using sql
23.09.2022 14:14:11
ChrisL
Hi

SELECT TALLY_TRAN_MSTR.LOGON_ID, Sum(TALLY_TRAN_MSTR.FULL_PLLT_QTY), TALLY_TRAN_MSTR.SHIFT_DT, TALLY_TRAN_MSTR.PRI_GRP_CD
FROM WBR_RW.TALLY_TRAN_MSTR
WHERE TALLY_TRAN_MSTR.PRI_GRP_CD = "PUT"
GROUP BY TALLY_TRAN_MSTR.LOGON_ID, TALLY_TRAN_MSTR.SHIFT_DT, TALLY_TRAN_MSTR.PRI_GRP_CD
cu
Chris
Why is str.swapcase used? (). In Python, swapcase(
12.12.2022 13:10:04
billy21
According to the documentation (https://www.scaler.com/topics/swapcase-in-python/), s.swapcase() == s is not necessarily true. So why not? When I first read this, I assumed it had something to do with the.casefold technique; but, I couldn't figure it out and couldn't discover anything with an Internet search.
Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige

Beliebteste Forumthreads (12 Monate)

Anzeige
Anzeige
Anzeige