Herr Franzen:
Vilken fascinerande forskning! Jag skulle gärna vilja veta om och när
den engelska versionen finns tillgänglig.
Med vänliga hälsningar, Bruce
What fascinating research! I would love to know if and when the English
version is available.
Very Best, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com
Translation via DeepL
------ Original Message ------
From "'Bo Franzén' via RBASE-L" <rbase-l@googlegroups.com>
To "rbase-l@googlegroups.com" <rbase-l@googlegroups.com>
Date 6/22/2023 11:15:49 AM
Subject SV: SV: [RBASE-L] - Second ORDER BY parameter?
Yeas, everything is OK with me. I hope the same goes for you Karen. I
had a faint memory that the two column parameter didn't work for me,
but that was a real long time ago.
Y s
Bo Franzén
--------------------------------------------------------------------------------
Från: 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com>
Skickat: den 22 juni 2023 19:38:13
Till:rbase-l@googlegroups.com
Ämne: Re: SV: [RBASE-L] - Second ORDER BY parameter?
Just a case of not seeing the forest for the trees!!
Hope all is well with you
Karen
-----Original Message-----
From: 'Bo Franzén' via RBASE-L <rbase-l@googlegroups.com>
To: rbase-l@googlegroups.com <rbase-l@googlegroups.com>
Sent: Thu, Jun 22, 2023 11:11 am
Subject: SV: [RBASE-L] - Second ORDER BY parameter?
Karen, exactly! I blush, it worked, it was as simple as that. Many
thanks.
Bo Franzén
--------------------------------------------------------------------------------
Från: 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com>
Skickat: den 22 juni 2023 17:53:43
Till:rbase-l@googlegroups.com
Ämne: Re: [RBASE-L] - Second ORDER BY parameter?
Sorry Bo, I'm probably not understanding. Are you asking if you can
sort by two columns? Like: ORDER BY commodity ASC, tran_id ASC
Karen
-----Original Message-----
From: 'Bo Franzén' via RBASE-L <rbase-l@googlegroups.com>
To: R:BASE <rbase-l@googlegroups.com>
Sent: Thu, Jun 22, 2023 10:47 am
Subject: [RBASE-L] - Second ORDER BY parameter?
Dear R:BASE,
I have a coming printed volume with ca 8000 rows with Medieval Swedish
commodity prices in (of course) R:BASE. The rows are originally in
Swedish alphabetical order and every commodity are sorted in
chronological order. All thanks to a unique key, tran_id, where the
lower tran_id the older a price. My scholar colleagues in this long
time-consuming project suddenly wanted the volume to be published in
English, so I added columns for that translation. Only a few goods have
the same name and spelling in Swedish and English and the publisher
want an export i excel in English alphabetical order. Said and done,
R>... ORDER BY commodity ASC.
To exemplify below with selected columns: almond comes in the beginning
of my export in English. But when the data is being exported the
chronological order is "forgotten". This is no cow on the ice, as we
say in Sweden, because it can be fixed in excel by going through
commodity after commodity. Just want to check if there is an SQL way of
ORDER BY first and second?
I wish the whole R:BASE society A HAPPY MIDSUMMER!
Bo Franzén
Department of Economic History
Stockholm University
tran_id
year
vara
commodity
numeral
enhet
price öre
39301
1470
mandel
almond
markpound
markpund
0,66
39291
1468
mandel
almond
markpound
markpund
0,66
39321
1473
mandel
almond
markpound
markpund
1,00
39341
1503
mandel
almond
pound
pund
20,00
39351
1511
mandel
almond
pound
skålpund
2,66
39311
1472
mandel
almond
markpound
markpund
1,33
39281
1465
mandel
almond
markpound
markpund
1,33
39251
1463
mandel
almond
markpound
markpund
2,66
39261
1463
mandel
almond
pound
pund
8,00
39231
1328
mandel
almond
pound
skålpund
0,60
39241
1462
mandel
almond
markpound
markpund
0,83
39361
1513
mandel
almond
pound
skålpund
1,00
39371
1515
mandel
almond
pound
pund
2,33
39271
1464
mandel
almond
markpound
markpund
1,00
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/38fed557dacc449390804213ebc16c44%40ekohist.su.se
<https://groups.google.com/d/msgid/rbase-l/38fed557dacc449390804213ebc16c44%40ekohist.su.se?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/844702668.2792824.1687449223967%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/844702668.2792824.1687449223967%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/4a3b6f6a2a374264a594abc054fce30d%40ekohist.su.se
<https://groups.google.com/d/msgid/rbase-l/4a3b6f6a2a374264a594abc054fce30d%40ekohist.su.se?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/376989207.2824896.1687455493875%40mail.yahoo.com
<https://groups.google.com/d/msgid/rbase-l/376989207.2824896.1687455493875%40mail.yahoo.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/e3290d33ed244b56af49349be786ed28%40ekohist.su.se
<https://groups.google.com/d/msgid/rbase-l/e3290d33ed244b56af49349be786ed28%40ekohist.su.se?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em5a127424-28b5-42ea-9c74-bdb1102b172b%4008b3bc0f.com.
