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
---
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/38fed557dacc449390804213ebc16c44%40ekohist.su.se.
