Re[5]: [RBASE-L] - Second ORDER BY parameter? | Thank you

Thu, 22 Jun 2023 14:16:24 -0700 

Bo:

Thank you. Very impressive work.
Bruce


------ 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:41:41 AM
Subject SV: Re[3]: [RBASE-L] - Second ORDER BY parameter?


Thank you Bruce,
This is not our first work, we also have studied land prices. And among other things, in December 2022 we published an urban property price index for Stockholm 1420-2020 with articles with the help of the central bank of Sweden (see pdf). I promise to tell you (e.g. R:BASE) when we are done with this commodity book in two volumes. 😃 



Y s

Bo Franzén





--------------------------------------------------------------------------------
FrÄn:rbase-l@googlegroups.com <rbase-l@googlegroups.com> för Bruce Chitiea <rby...@safesectors.com> 
Skickat: den 22 juni 2023 20:24:43
Till:rbase-l@googlegroups.com
Ämne: Re[3]: [RBASE-L] - Second ORDER BY parameter?

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 <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 <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 <https://groups.google.com/d/msgid/rbase-l/em5a127424-28b5-42ea-9c74-bdb1102b172b%4008b3bc0f.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/2144a5a73ebd4d69acf91630513e8c84%40ekohist.su.se <https://groups.google.com/d/msgid/rbase-l/2144a5a73ebd4d69acf91630513e8c84%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/em90b67282-71d4-4511-a9cd-d2fbb5ee2ab5%4008b3bc0f.com.

Reply via email to