使用sqlite sql，我如何获得记录升序 [英] Using sqlite sql, how do i get records ascending
问题描述
我有一个sql说：从员工订单中选择*姓氏
在档案中我有AAAAAA，aaaaaa，BBBBBB，bbbbbb
结果是AAAAAA，BBBBBB ，aaaaaa，bbbbbb
它应该是aaaaaa AAAAAA bbbbbb BBBBBB
如何才能正确使用？
我尝试了什么：
我有一个sql说：从员工订单中选择*姓氏
存档我有AAAAAA，aaaaaa，BBBBBB，bbbbbb
结果是AAAAAA，BBBBBB，aaaaaa，bbbbbb
它应该是aaaaaa AAAAAA bbbbbb BBBBBB
如何才能正确使用？
I have an sql that says: Select * from employee order by lastname
On file I have AAAAAA, aaaaaa, BBBBBB, bbbbbb
The result is AAAAAA, BBBBBB, aaaaaa, bbbbbb
It should be aaaaaa AAAAAA bbbbbb BBBBBB
how do I get this correct?
What I have tried:
I have an sql that says: Select * from employee order by lastname
On file I have AAAAAA, aaaaaa, BBBBBB, bbbbbb
The result is AAAAAA, BBBBBB, aaaaaa, bbbbbb
It should be aaaaaa AAAAAA bbbbbb BBBBBB
how do I get this correct?
推荐答案
这很复杂，因为它给你的顺序是正确的：大写字母在我见过的每个字符集中小写字母之前！
看看ASCII表 https://upload.wikimedia.org/wikipedia/commons/thumb/1/1b/ASCII-Table-wide.svg/2000px-ASCII-Table-wide.svg.png [ ^ ]或通过Character Map设置的Windows字符，你会看到我的意思。
结果，字符串的默认ORDER BY（如果在它比较的两个字符串中找到，则对第一个不同的字符起作用）将始终首先放大写。
您可以通过指定区分大小写的排序规则在SQL中执行此操作： br />
That's quite complex, because the order it gives you is correct: uppercase letters come before lower case in every character set I have ever seen!
Have a look at the ASCII Table https://upload.wikimedia.org/wikipedia/commons/thumb/1/1b/ASCII-Table-wide.svg/2000px-ASCII-Table-wide.svg.png[^] or a Windows character set via "Character Map" and you'll see wht I mean.
As a result, the default ORDER BY for strings (which works on the first different character if finds in the two strings it compares) will always put uppercase first.
You can do it in SQL by specifying a case sensitive collation:
SELECT * FROM MyTable ORDER BY Name COLLATE Latin1_General_CS_AS
但对于SQLite，我相信它是：
But for SQLite, I believe it's:
SELECT * FROM MyTable ORDER BY Name COLLATE NOCASE我可以检查一下，但目前我还没有提供SQLite。
尽管在创建时将COLLATION应用到列中，但是要快得多！
I can;t check that though, I don't have SQLite available at the moment.
It's a lot, lot quicker though to apply the COLLATION to the column when you create it though!
这篇关于使用sqlite sql，我如何获得记录升序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
